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

Selective Viewing
 

Right click master sheet tabview codeinsert thisSAVE
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

"MBlake" wrote in message
...
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

Selective Viewing
 

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

Selective Viewing
 

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" wrote in message
...
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

Selective Viewing
 

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

"MBlake" wrote in message
...
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

Selective Viewing
 

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

Mickey