Alan

Why not post the code to the group?


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 19:53:05 +0100, "Alan" wrote:

I can, mail me personally on ', remove the
nospam, its done to avoid spam bombardment,
Regards,
Alan.

"neeraj" wrote in message
...
Can you provide the code for this

"Alan" wrote:

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?