Keeping Data Hidden

[ccmenden]

I'm looking for a way to keep data hidden in a sheet. I have used the group outline tool and the hidden columns tool.

What i have discovered is that even if I protect the sheet, another use can right click on the sheet and copy the sheet to a new sheet. And then have access to the hidden data.

Carol

 

[offthelip]

If you untick the box "Select Locked Cells" when you protect the sheet it will prevent users selecting the cell and thus they can't copy them