Selective Viewing

Hi,
Is it possible to require a logon and password to access a worksheet and
then display the worksheet relevant to the user?. For example, User A
enters their password and can then view worksheets 7 to 10, User B logs in
and can access Worksheets 7 plus sheets 11 to 12.

If this is possible I'd be grateful for any web links or recommended
reading.

Thanks,
Mickey

Right click master sheet tab>view code>insert this>SAVE
add a sheet deactivate to set the password.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case UCase(Range("a2"))
Case Is = "JOE": x = 10
Case Is = "BILL": x = 2
Case Else: MsgBox "Not Authorized"
End Select
With Sheets("sheet" & x)
..Select
..Unprotect Password:=UCase(Range("a2"))
End With
End Sub

--
Don Guillett
SalesAid Software
donaldb@281.com
"MBlake" <mickeyblake@btinternet.com> wrote in message
news:uR6ab35YFHA.3780@tk2msftngp13.phx.gbl...
> Hi,
> Is it possible to require a logon and password to access a worksheet and
> then display the worksheet relevant to the user?. For example, User A
> enters their password and can then view worksheets 7 to 10, User B logs in
> and can access Worksheets 7 plus sheets 11 to 12.
>
> If this is possible I'd be grateful for any web links or recommended
> reading.
>
> Thanks,
> Mickey
>
>

Hi,
Many thanks for your assistance. I added the code to the worksheet object
and saved file but nothing. Do you know where I can find a tutorial on this
aspect of Excel?.

Thanks again,
Mickey

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

is an introduction to events.

Is that what you meant?

--
Regards,
Tom Ogilvy


"MBlake" <mickeyblake@btinternet.com> wrote in message
news:%23wuClvIZFHA.3184@TK2MSFTNGP15.phx.gbl...
> Hi,
> Many thanks for your assistance. I added the code to the worksheet object
> and saved file but nothing. Do you know where I can find a tutorial on
this
> aspect of Excel?.
>
> Thanks again,
> Mickey
>
>

You probably did not modify to fit YOUR situation.
Did you use cell a2 to type in the name Joe or Bill?
Do you have a sheet2 and a sheet10?

--
Don Guillett
SalesAid Software
donaldb@281.com
"MBlake" <mickeyblake@btinternet.com> wrote in message
news:%23wuClvIZFHA.3184@TK2MSFTNGP15.phx.gbl...
> Hi,
> Many thanks for your assistance. I added the code to the worksheet object
> and saved file but nothing. Do you know where I can find a tutorial on
this
> aspect of Excel?.
>
> Thanks again,
> Mickey
>
>

Thanks Guys,
I'm still working on this one.

Mickey