protect worksheet but allow row deletion

[Tia]

My worksheet is protected and many cells are either locked or unlocked. Rows
A10:A31 are unlocked, however, a user cannont delete any row in the rows
mentioned. How can I make this happen?

Thanks

 

[Michael]

It depends of your Excel version, in Excel 2003, during the protection
process you select:
Tools ->Protection -> Protect Sheet
Then check in the Allow all users of this worksheet to Box the Delete Rows
option.

 

[Tia]

Sorry I forgot to put that I'm using Excel 97.

It depends of your Excel version, in Excel 2003, during the protection
process you select:
Tools ->Protection -> Protect Sheet
Then check in the Allow all users of this worksheet to Box the Delete Rows
option.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[Michael]

Sorry, that was a bug in Excel 97. You will have to upgrade your software,
which with all due respect that is over 10 years old.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.