Inserting rows in a protected sheet - Office 2003

[Todd A]

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

 

[ShaneDevenshire]

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.

 

[Todd A]

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