MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell Protection


Posted by George on May 02, 2001 4:24 PM

Am I missing something?

I have a sheet which is the source data for numerous
pivot tables. I am making a copy of that sheet and
hiding the linked sheet.

Sheet 1 (source data) - which i have hidden and protected
Sheet 2 - a copy of sheet 1.
Sheets 3-10 - Pivot tables based on Sheet 1 source data

I am protecting the cells on the source data sheet if the
user realizes there is a hidden sheet and unhides
it. I have hidden columns and rows on the protected sheet
but if the user copies this to a new workbook those columns
and/or rows and the data can be easily seen (therefore
bypassing the protection).

Is there a fairly simple way to protect all of the data.
Either protecting the sheet so it cannot be access or
protecting the data if the sheet is accessed.

thanks


Posted by Mark W. on May 02, 2001 4:48 PM

Try Protect Workbook Structure.

Posted by George on May 02, 2001 5:04 PM

Nope same problem. Copy out to a new workbook and
then unhide the columns. All the data is visible.

Posted by George on May 02, 2001 5:06 PM

That actually protected against copying the whole sheet
but if you copy the hidden columns out that is when
you can see everything.

Posted by Mark W. on May 02, 2001 5:14 PM

However...

Protect Workbook Structure will prevent someone
from unhiding a hidden worksheet. Wasn't that
one of you're primary concerns?

> I am protecting the cells on the source data sheet
> if the user realizes there is a hidden sheet and
> unhides it That actually protected against copying the whole sheet

Posted by George on May 02, 2001 5:32 PM

Re: However...

BINGO

Thanks a bunch. Sometimes it is right in front of your
face.