Locking Sheets / Hiding Sheets

[Lee Harris]

Is it possible to hide sheets but prevent users from just unhiding them from
the Excel main menu? either they can't do it or need a password for example?

Likewise, what is the correct way to lock off cells in different sheets so
that only certain cells accept data and the user can't just unlock the other
cells

cheers

 

[Rowan Drummond]

To prevent users unhiding sheets protect the workbook. From the Menus
Tools>Protection>Protect Workbook. Add a password.

To have certain cells on a sheet unlocked and others locked, select the
cells you want to unlock (by default all cells are locked). Then
Format>Cells>Protection> Uncheck Locked. Then Tools>Protection>Protect
Sheet. Add a password.

Note this will prevent the average user from making unwanted changes.
Anybody a bit more determined will be able to crack the workbook and
worksheet protection passwords.

Hope this helps
Rowan

 

[Lee Harris]

To prevent users unhiding sheets protect the workbook. From the Menus
Tools>Protection>Protect Workbook. Add a password.

To have certain cells on a sheet unlocked and others locked, select the
cells you want to unlock (by default all cells are locked). Then
Format>Cells>Protection> Uncheck Locked. Then Tools>Protection>Protect
Sheet. Add a password.

Note this will prevent the average user from making unwanted changes.
Anybody a bit more determined will be able to crack the workbook and
worksheet protection passwords.

Hope this helps
Rowan

thanks
don't you mean the default for cells is "unlocked"?

 

[Rowan Drummond]

Hi Lee

No, the default for cells is locked. However, this only comes into
affect when you protect the sheet. So if you add a new sheet and then
protect that sheet every cell will be locked. Hence the need to unlock
the cells in which you want your users to enter data before protecting
the sheet.

Regards
Rowan

 

[Arvi Laanemets]

Hi

You can set sheet(s) to be Very Hidden in VBA-Project window (Alt+F11,
select the sheet in leftmost upper window, and edit Visible property). When
the sheet is very hidden, it doesn't appear in list of sheets to unhide in
Format>Sheet menu.

When in VBA editor, you also can after setting the sheet to be very hidden
protect your VBA project with password - so other users can't open it to set
sheet(s) visible manually (at least not without some cracking)