HIDING ROWS IN PROTECTED WORKSHEETS
Hi,
I hid some rows when protecting a worksheet and sent to a friend. The idea
is that he is not able to view the rows when he opened the protected
worksheet. However, he is able to get around this by copying the worksheet
and presto! all the hidden rows are shown.
Is there a way to protect hidden rows from being shown when a protected
worksheet is copied and pasted to a new worksheet? Thanks
|