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
|
|||
|
|||
Inserting rows in a protected sheet - Office 2003
Hello,
The function 'Insert Row' in the window when Protect sheet is selected is supposed to allow row insertion in a protected sheet. I have 24 sheets that are protected for a billing spread sheet. The spread sheet is 25 MB in size, adding additional rows in the 'event of' drastically increases the size of this spread sheet and unlocking the sheets is time consuming and dangerous when done by persons not fluent in Excel. Keep in mind that if a row is added in one it must be add in all sheets. How can this error be corrected? Thanks |
#2
|
|||
|
|||
Inserting rows in a protected sheet - Office 2003
Hi Todd,
I not exactly sure what your problem is, but if it is how do you insert rows in many sheets, then click the first sheet tab into which you want to insert a row, hold down the Shift key and click the last sheet that you want to add the row to. This will select all the sheets between the first and the last. If they are not adjacent use Ctrl key as you click each sheet. Select the row(s) you want to insert and press Ctrl + (Ctrl plus the + key) On the top keyboard you need to press Shift Ctrl + but on the number keypad just Ctrl + of course you could use the menu command Insert, Rows or the toolbar button. -- Cheers, Shane Devenshire "Todd A" wrote: Hello, The function 'Insert Row' in the window when Protect sheet is selected is supposed to allow row insertion in a protected sheet. I have 24 sheets that are protected for a billing spread sheet. The spread sheet is 25 MB in size, adding additional rows in the 'event of' drastically increases the size of this spread sheet and unlocking the sheets is time consuming and dangerous when done by persons not fluent in Excel. Keep in mind that if a row is added in one it must be add in all sheets. How can this error be corrected? Thanks |
#3
|
|||
|
|||
Inserting rows in a protected sheet - Office 2003
Hello ShaneDevenshire,
Now solved The real problem is each sheet has to be unprotected first as Excel 2003's insert row function does not work when more then one sheet is selected. This operation is too much for our Excel users not to mention very time consuming. I created 3 macro's to deal with this and assigned the macros to three buttons on the first spread sheet. The first unprotects the 24 sheets and then selects all the sheets. The second button then selects the row where ever the cell pointer is located and then it inserts a row below that and copies the contents of the row selected to the new row (for all 24 sheets). The third button unselects all tabs and protects the 24 sheets. (now ready for data entry). I do appreciate your help Thanks "ShaneDevenshire" wrote: Hi Todd, I not exactly sure what your problem is, but if it is how do you insert rows in many sheets, then click the first sheet tab into which you want to insert a row, hold down the Shift key and click the last sheet that you want to add the row to. This will select all the sheets between the first and the last. If they are not adjacent use Ctrl key as you click each sheet. Select the row(s) you want to insert and press Ctrl + (Ctrl plus the + key) On the top keyboard you need to press Shift Ctrl + but on the number keypad just Ctrl + of course you could use the menu command Insert, Rows or the toolbar button. -- Cheers, Shane Devenshire "Todd A" wrote: Hello, The function 'Insert Row' in the window when Protect sheet is selected is supposed to allow row insertion in a protected sheet. I have 24 sheets that are protected for a billing spread sheet. The spread sheet is 25 MB in size, adding additional rows in the 'event of' drastically increases the size of this spread sheet and unlocking the sheets is time consuming and dangerous when done by persons not fluent in Excel. Keep in mind that if a row is added in one it must be add in all sheets. How can this error be corrected? Thanks |
Thread Tools | |
Display Modes | |
|
|