Re: Losing all row height formatting when copying a worksheet.

> In article ,
> Guest wrote:
>
> > I also have this problem. When copying a protected worksheet I loose
all row
> > height settings and all hidden rows become visable, this defeats the
point of
> > having protected cells :angry:
>
> The purpose of having protected cells is to prevent inadvertent changes
> in them.
>
> Row height is a property of *rows* not individual cells. To copy row
> height, copy the *row*.
>

This problem occurs even with unprotected sheets. I can't copy a sheet,
even within the same workbook, without losing all row height formatting.
This is not the way any previous version of excel worked.