Password protection for a worksheet within a workbook

[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.

 

[David Hager]

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