If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Allow Insert Rows in a protected worksheet
In the Protect Sheet dialog in Excel 2003, I check Insert Rows ("Allow all
users of this worksheet to:"). I enter and confirm a password. The worksheet is protected, but Inserting Rows is disabled. What am I missing? -- Best, Andrew-K |
#2
|
|||
|
|||
Allow Insert Rows in a protected worksheet
Probably not missing anything - there are several options available in that
dialog that don't actually work once the sheet is protected. Or at least not the way you'd think they would. But this is one that actually seems to work for me. You might try this to see if it helps: Unprotect the sheet and choose 1 row, any row, and unprotect that row (with row selected; Format Cells and clear the [Locked] checkbox in the dialog). Now do your protecting again and see if you can't insert a new row, if you can, I believe you can then once again unprotect the sheet, set that row's property back to [Locked] if you want to and then insert/delete rows option will/should still work for you. "andrew-k" wrote: In the Protect Sheet dialog in Excel 2003, I check Insert Rows ("Allow all users of this worksheet to:"). I enter and confirm a password. The worksheet is protected, but Inserting Rows is disabled. What am I missing? -- Best, Andrew-K |
#3
|
|||
|
|||
Allow Insert Rows in a protected worksheet
Hi,
Make sure you can use the command against the same selection with protection off. One reason you might not be able to insert rows is if you are in Group Mode with another sheet protected. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "andrew-k" wrote: In the Protect Sheet dialog in Excel 2003, I check Insert Rows ("Allow all users of this worksheet to:"). I enter and confirm a password. The worksheet is protected, but Inserting Rows is disabled. What am I missing? -- Best, Andrew-K |
Thread Tools | |
Display Modes | |
|
|