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

K,

Sheet protection is to protect the sheet from being changed. Copying the
sheet doesn't change the sheet, so Protection thinks it's done its job.

A way to keep data hidden is to put it in another worksheet, which you can
hide in its entirety. Use references to those cells in formulas in the
original cells, just as the formulas do now, if any. To keep someone from
unhiding the sheet, you can use the VBE to set the sheet's Visible property
to xlSheetVeryHidden (yes, there is such a thing), then lock the project
with a password.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"kyoung" wrote in message
...
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

Earl
Thanks for your response.

Based on what you've said, there is no other way to prevent hidden rows from
hiding when protected worksheet is copied? I understand your method. I just
thought there could be an easier way to do it.

Once again, thank you very much.


"Earl Kiosterud" wrote:

K,

Sheet protection is to protect the sheet from being changed. Copying the
sheet doesn't change the sheet, so Protection thinks it's done its job.

A way to keep data hidden is to put it in another worksheet, which you can
hide in its entirety. Use references to those cells in formulas in the
original cells, just as the formulas do now, if any. To keep someone from
unhiding the sheet, you can use the VBE to set the sheet's Visible property
to xlSheetVeryHidden (yes, there is such a thing), then lock the project
with a password.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"kyoung" wrote in message
...
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