| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
