Password view on worksheet

G

gacollege

Is there a way to password protect view on a worksheet?

ie. I have a workbook and I only want the manager responsible fo
worksheet be able to view it
 
R

RagDyeR

<File> <SaveAs> <Tools> <GeneralOptions>
Enter password in "PassWordToOpen" box.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to password protect view on a worksheet?

ie. I have a workbook and I only want the manager responsible for
worksheet be able to view it.
 
G

gacollege

Thanks, but this only asks for the password for the entire workbook, I
would like all managers to be able to open workbook, but only have the
managers open their respective tab (worksheet).

Make sense?
 
D

Don Guillett

something like this?

Sub passwordmgr()
Select Case UCase(InputBox("Enter password"))
Case "JOE"
Sheets("Joe").Visible = True
Case "BILL"
Sheets("Bill").Visible = True
Case Else
End Select
End Sub
 
G

gacollege

Don, I think this is what I am needing. How so I make it work.....??
(Limted VBA/Macro experience)
 
D

Don Guillett

Gord's posting should explain it all. For the unlock macro you can use the
if/else if or the select I suggested.

--
Don Guillett
SalesAid Software
[email protected]
gacollege > said:
Don, I think this is what I am needing. How so I make it work.....???
(Limted VBA/Macro experience)
Click to expand...
 
Top