protect worksheet but allow row deletion


T

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
 
Ad

Advertisements

M

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.
 
T

Tia

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

Michael said:
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.
 
Ad

Advertisements

M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top