And you have access to all 12 worksheets as well? So you want 12 separate
passwords written down? If their workstations are protected it might be
easier to split it into 12 workbooks. Only access to Emp1's worksheet is to
login with Emp1's username/password.
"neeraj" wrote:
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?
|