Password view on worksheet

  • Thread starter Thread starter gacollege
  • Start date Start date
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
 
<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.
 
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?
 
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
 
Don, I think this is what I am needing. How so I make it work.....??
(Limted VBA/Macro experience)
 
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
(e-mail address removed)
gacollege > said:
Don, I think this is what I am needing. How so I make it work.....???
(Limted VBA/Macro experience)
Click to expand...
 
Back
Top