Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Sheets / Hiding Sheets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Sheets / Hiding Sheets
To prevent users unhiding sheets protect the workbook. From the Menus
ToolsProtectionProtect 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 FormatCellsProtection Uncheck Locked. Then ToolsProtectionProtect 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 wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Sheets / Hiding Sheets
"Rowan Drummond" wrote in message ... To prevent users unhiding sheets protect the workbook. From the Menus ToolsProtectionProtect 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 FormatCellsProtection Uncheck Locked. Then ToolsProtectionProtect 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"? Lee Harris wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Sheets / Hiding Sheets
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 Lee Harris wrote: "Rowan Drummond" wrote in message ... To prevent users unhiding sheets protect the workbook. From the Menus ToolsProtectionProtect 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 FormatCellsProtection Uncheck Locked. Then ToolsProtectionProtect 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"? Lee Harris wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Sheets / Hiding Sheets
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 FormatSheet 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) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Lee Harris" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
Locking certain sheets | Excel Discussion (Misc queries) | |||
Hiding Sheets | Setting up and Configuration of Excel | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) | |||
Hiding Sheets | Excel Worksheet Functions |