It can be done by using code to provide the passwords to individual
worksheets and password protecting each sheet and also password protecting
the workbook itself.
The way it can works is that the user is given the option of Enabling or
Disabling Macros on opening. If the file is opened with Macros disabled then
all sheets and the workbook are hidden and cannot be unhidden without the
password, they can only be accessed by Enabling Macro's on start up and
using the instructions you provide in the code you write.
Note however that the protection provided in XL is primarily meant to avoid
mistakes such as inadvertently overwriting a formula, not for real
protection. Any kind of protection you put on a worksheet can be easily
overcome by code available on these very forums by anyone who has the will
and knowledge to do so,
Regards,
Alan.
wrote in message
...
I have a workbook with 12 worksheets or tabs say Tab1, Tab2...Tab12 in it,
each dedicated to one of 12 employees respectively to say Emp1,
Emp2,..Emp12.
The requirement is to set up protection such that Emp1 can read only Tab1
(other tabs should be either greyed out or not visible to Emp1), Emp2 can
read only Tab2 and so on. Can this be done?