[SOLVED] granting access to view a worksheet

I created a workbook with 5 sheets for users in my office. However, I only
want certain users to be able to VIEW one or two worksheets. How can I
restrict certain users from access to some worksheets? Thanks

Have you tried hiding the other sheets?
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"bwaguespack" <[email protected]> wrote in message
news:[email protected]...
>I created a workbook with 5 sheets for users in my office. However, I only
> want certain users to be able to VIEW one or two worksheets. How can I
> restrict certain users from access to some worksheets? Thanks

I can hide it, but isnt it just as easy for another user to unhide it? I
want to make sure it is not accessible to the restricted users.

"Bernard Liengme" wrote:

> Have you tried hiding the other sheets?
> best wishes
> --
> Bernard Liengme
> www.stfx.ca/people/bliengme
> remove CAPS in email address
>
>
> "bwaguespack" <[email protected]> wrote in message
> news:[email protected]...
> >I created a workbook with 5 sheets for users in my office. However, I only
> > want certain users to be able to VIEW one or two worksheets. How can I
> > restrict certain users from access to some worksheets? Thanks
>
>
>

In Visual Basic there is a VeryHidden status.

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"bwaguespack" <[email protected]> wrote in message
news:[email protected]...
>I can hide it, but isnt it just as easy for another user to unhide it? I
> want to make sure it is not accessible to the restricted users.
>
> "Bernard Liengme" wrote:
>
>> Have you tried hiding the other sheets?
>> best wishes
>> --
>> Bernard Liengme
>> www.stfx.ca/people/bliengme
>> remove CAPS in email address
>>
>>
>> "bwaguespack" <[email protected]> wrote in message
>> news:[email protected]...
>> >I created a workbook with 5 sheets for users in my office. However, I
>> >only
>> > want certain users to be able to VIEW one or two worksheets. How can I
>> > restrict certain users from access to some worksheets? Thanks
>>
>>
>>