Prevent copying data

[Walter in Wisconsin]

I have payroll information that is hidden on a page in a work book. I have hidden these cells but people could copy the page and have access to all the data. I want to leave cells in the spreadsheet that can be hard coded by the user, but I don't want people to be able to access the confidential payroll data within. Any ideas? Thanks

 

[Macropod]

Hi Walter,

You can't really protect the data that way. A somewhat more secure approach would be to put the data on a hidden worksheet. If you use vba to hide a worksheet, there's a 'evryhidden' property that prevents the worksheet from being unhidden via Format|Sheet|Unhide. Better still is to put the data in a separate workbook, which then doesn't have to be made available to others.

Cheers