Restricting Read Access to Individual Sheets in Excel

[beanxx]

Hi, I have a single spreadsheet made up of a number of sheets where each sheets contains information specific to an individual customer. Is it possible to restrict read access to certain sheets of the spreadsheets through passwords? For instance anyone can see the "header" sheet. But Sheet One can only be read by certain people via a password, the same goes for sheet Two, etc?

Thanks,

Justin

 

[SkipVought]

Hi,

Nothing built into Excel. But it can be done using VBA by making sheets visible or not with password control.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[fredericofonseca]

see thread68-647974

In addition to what is on the thread you would need to add "hidden" worksheets, and unhide then depending on the password.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[beanxx]

Thanks everyone. I wasn't sure if there was a quick fix using passwords but I'll go through the VBA route.

Justin