Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting Worksheet
Is there any way to protect a workbook and still let users enter in
information on certain cell? Also, is there any way to protect the page setup of a Workbook? Thanks in advance for any help. |
#2
|
|||
|
|||
Hi
By default, all cells are locked - but the sheet is unprotected. Hit Ctrl+A to select all cells and then from Format/Cells/Protection, uncheck Locked. Now all of your cells are unlocked. Select the cell/s you wish to lock and Format/Cells/Protection select Locked. To activate this, you now need to protect the worksheet, from Tools/Protection/Protect Worksheet Hope this helps. -- Andy. "Tony" wrote in message ... Is there any way to protect a workbook and still let users enter in information on certain cell? Also, is there any way to protect the page setup of a Workbook? Thanks in advance for any help. |
#3
|
|||
|
|||
Do you know if there is any way to protect things like the margins on the
page setup? Thanks "Andy B" wrote: Hi By default, all cells are locked - but the sheet is unprotected. Hit Ctrl+A to select all cells and then from Format/Cells/Protection, uncheck Locked. Now all of your cells are unlocked. Select the cell/s you wish to lock and Format/Cells/Protection select Locked. To activate this, you now need to protect the worksheet, from Tools/Protection/Protect Worksheet Hope this helps. -- Andy. "Tony" wrote in message ... Is there any way to protect a workbook and still let users enter in information on certain cell? Also, is there any way to protect the page setup of a Workbook? Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Protecting a Worksheet but ability to Sort | Excel Discussion (Misc queries) | |||
Auto Skipping and Protecting Worksheet | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Protecting specific cells in a worksheet. | Excel Worksheet Functions |