Password Protection

K

kennyken

Hi all

I have a spreadsheet with several sheets . These are accessed via macr
buttons on a main fron sheet (I have hidden other sheets) . Is i
possible to password protect certain sheets so that they cannot b
accessed by the user without the correct password . I can protect the
so that they cannot be changed but need to stop them from bein
accessed

Thanks

Kiera
 
D

DNF Karran

First Hide the sheet by going Format/Sheet/Hide on the toolbar.

If you then protect the workbook structure the user will be unable t
unhide the sheet.

Dunca
 
D

Don Guillett

You can use something like this so that the sheet cannot be unhidden except
by code. Use with an input box asking for the password to unhide.

Sub hidesheet()'change comment to unhide
'Sheets("sheet11").Visible = xlVeryHidden
Sheets("sheet11").Visible = True

End Sub
 
Top