Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Protection
Hello All,
I'm sure its something simple, but I am having trouble protecting specific cells in a worksheet. Followed the help instructions, but not having any luck. Need to protect a row of headers and the next rows will be used by others, but need to protect the format only of the blank rows. Using Excel 2000 Appreciate your advice. Thank you everyone Sue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Protection
You need to unlock the cells which you want the Users to adjust -
highlight the cells and click on Format | Cells | Protection tab and unclick Locked and Hidden for those cells. Now apply Tools | Protection | Protect Sheet (with or without a password), and the cells which were not changed (i.e. your headers) will now be locked. In later versions of Excel there are some options as to what a User is allowed to do in a protected sheet, but those were not available in XL 2000 - it's all or nothing. Hope this helps. Pete On Jan 18, 10:29*pm, Susan wrote: Hello All, I'm sure its something simple, but I am having trouble protecting specific cells in a worksheet. *Followed the help instructions, but not having any luck. Need to protect a row of headers and the next rows will be used by others, but need to protect the format only of the blank rows. *Using Excel 2000 Appreciate your advice. Thank you everyone Sue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Protection
Thank you Pete, will give it another try.
"Pete_UK" wrote: You need to unlock the cells which you want the Users to adjust - highlight the cells and click on Format | Cells | Protection tab and unclick Locked and Hidden for those cells. Now apply Tools | Protection | Protect Sheet (with or without a password), and the cells which were not changed (i.e. your headers) will now be locked. In later versions of Excel there are some options as to what a User is allowed to do in a protected sheet, but those were not available in XL 2000 - it's all or nothing. Hope this helps. Pete On Jan 18, 10:29 pm, Susan wrote: Hello All, I'm sure its something simple, but I am having trouble protecting specific cells in a worksheet. Followed the help instructions, but not having any luck. Need to protect a row of headers and the next rows will be used by others, but need to protect the format only of the blank rows. Using Excel 2000 Appreciate your advice. Thank you everyone Sue |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Protection
You're welcome, Susan.
Pete On Jan 19, 12:53*am, Susan wrote: Thank you Pete, will give it another try. "Pete_UK" wrote: You need to unlock the cells which you want the Users to adjust - highlight the cells and click on Format | Cells | Protection tab and unclick Locked and Hidden for those cells. Now apply Tools | Protection | Protect Sheet (with or without a password), and the cells which were not changed (i.e. your headers) will now be locked. In later versions of Excel there are some options as to what a User is allowed to do in a protected sheet, but those were not available in XL 2000 - it's all or nothing. Hope this helps. Pete On Jan 18, 10:29 pm, Susan wrote: Hello All, I'm sure its something simple, but I am having trouble protecting specific cells in a worksheet. *Followed the help instructions, but not having any luck. Need to protect a row of headers and the next rows will be used by others, but need to protect the format only of the blank rows. *Using Excel 2000 Appreciate your advice. Thank you everyone Sue- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Worksheet Functions |