worksheet protection reading

[neeraj]

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?

[Mike]

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?

[neeraj]

Yes, the supervisor of these 12 employees should have access to all 12 tabs.
Yes, there would be 12 different usernames (and passwords). Emp1 should have
access only to Tab1 worksheet when he opens the workbook
"Mike" wrote:

> 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?

[Alan]

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.
<[email protected]> wrote in message
news:[email protected]...
>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?

[neeraj]

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.
> <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>

[Alan]

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

"neeraj" <[email protected]> wrote in message
news:[email protected]...
> 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.
>> <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>>
>>
>>

[Gord Dibben]

Alan

Why not post the code to the group?


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 19:53:05 +0100, "Alan" <[email protected]> wrote:

>I can, mail me personally on '[email protected]', remove the
>nospam, its done to avoid spam bombardment,
>Regards,
>Alan.
>
>"neeraj" <[email protected]> wrote in message
>news:[email protected]...
>> 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.
>>> <[email protected]> wrote in message
>>> news:[email protected]...
>>> >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?
>>>
>>>
>>>
>

[Alan]

I was just going to send a workbook that I already have directly,
Regards,
Alan.
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Alan
>
> Why not post the code to the group?
>
>
> Gord Dibben Excel MVP
>
> On Tue, 20 Sep 2005 19:53:05 +0100, "Alan" <[email protected]> wrote:
>
>>I can, mail me personally on '[email protected]', remove
>>the
>>nospam, its done to avoid spam bombardment,
>>Regards,
>>Alan.
>>
>>"neeraj" <[email protected]> wrote in message
>>news:[email protected]...
>>> 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.
>>>> <[email protected]> wrote in message
>>>> news:[email protected]...
>>>> >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?
>>>>
>>>>
>>>>
>>
>