Protect a worksheet with a password

[Guest]

I have 20+ worksheets in a single workbook - I want to protect only one of
those worksheets with a password. (I don't want anyone to be able to view
that specific worksheet unless they have the password.) How can I do this?

 

[Bob Umlas]

Viewing a worksheet is not prevented by password protecting it. Try
something like this. If Sheet2 should be the "culprit": right-click the
sheet tab for Sheet2, select View Code, Put this code in:

Private Sub Worksheet_Activate()
With ActiveWindow
.Windowstate=xlminimized
If inputbox("Password?") <> "Putyourpasswordhere" Then
Sheets(1).Select
.Windowstate=xlmaximized
End With
End Sub

Bob Umlas
Excel MVP

I have 20+ worksheets in a single workbook - I want to protect only one of
those worksheets with a password. (I don't want anyone to be able to view
that specific worksheet unless they have the password.) How can I do

this?

 

[Gord Dibben]

You can hide the sheet using Format>Sheet>Hide.

Then Protect the Workbook(not worksheet) for Windows and Structure.

NOTE: password protection in Excel is easily cracked so don't use this method if
the sheet data is sensitive.


Gord Dibben MS Excel MVP