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.