inserting rows on protected worksheet

MikeL · Mar 19th, 2002, 07:10 AM

Am new to board and was wondering if anyone has suggestions for how to insert rows onto a protected worksheet. I designed an Excel template but protected the worksheet (not the workbook) to preserve the file integrity. Some end users need to insert more rows into the spreadsheet. This option is ghosted. Any ideas? Also, am using Excel 2000.
Thanks in advance,
MikeL

Dave Hawley · Mar 19th, 2002, 07:33 AM

Hi Mike

Excel XP has a lot more flexibility in this are but For 2000 or less you will need a macro:

Sub InsertaRow()
On Error GoTo ProtectAgain
ActiveSheet.Unprotect password:="secret"
ActiveCell.EntireRow.Insert
ProtectAgain:
ActiveSheet.Protect password:="secret"
End Sub

Push Alt+F11, go to Insert>Module and paste in the code. Push Alt+Q then Alt+F8, select the macro name and click "options" to assign a shortcut key.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 07:10 AM	#1
MikeL Board Regular Join Date: Mar 2002 Posts: 183	Am new to board and was wondering if anyone has suggestions for how to insert rows onto a protected worksheet. I designed an Excel template but protected the worksheet (not the workbook) to preserve the file integrity. Some end users need to insert more rows into the spreadsheet. This option is ghosted. Any ideas? Also, am using Excel 2000. Thanks in advance, MikeL

Mar 19th, 2002, 07:33 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Mike Excel XP has a lot more flexibility in this are but For 2000 or less you will need a macro: Sub InsertaRow() On Error GoTo ProtectAgain ActiveSheet.Unprotect password:="secret" ActiveCell.EntireRow.Insert ProtectAgain: ActiveSheet.Protect password:="secret" End Sub Push Alt+F11, go to Insert>Module and paste in the code. Push Alt+Q then Alt+F8, select the macro name and click "options" to assign a shortcut key.