![]() |
Worksheet protection problem
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. |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com