inserting rows on protected worksheet

[MikeL]

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]

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.