Password protection for a worksheet within a workbook

  • Thread starter Thread starter Max L. Eidswick
  • Start date Start date
M

Max L. Eidswick

Is there any way to password protect individual
worksheets in a workbook? I want to have a master
workbook for several projects I am working on, where
several people may have access to it. I want to insure
only specific people can read/see certain worksheets.
 
You need to write a procedure that runs when you open the workbook
(Workbook_Open event). Provide an input box for various passwords and use a
Select Case statement to run code based on that input that hides designated
worksheets.

David Hager
Excel FMVP
 
Back
Top