Worksheet protection problem

F

Frederick Chow

Hi all,

I have the following worksheet protection problem in Excel 2003.

Replicaton of the problem:

1. In a worksheet, unlock the range A2:F6 (in fact any rectangular range
will do).
2. in Tools | Protection | Protect Sheets:
a. Protect worksheets and contents of locked cells
b. Check the "select locked cells) check box.
c. allow all users of worksheet to insert and delete rows.
3. Now highlight the range A3:F3.
4. Select Insert | Row. Note that you can allow to insert rows.

Q: How can I delete rows??

Thanks for your advice in advance.

Frederick Chow
Hong Kong.
 

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