Worksheet Protection

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

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
 
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
 
Thank you Pete, will give it another try.

Pete_UK said:
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
Click to expand...
 
Back
Top