inserting rows on protected worksheet
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: inserting rows on protected worksheet

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    392
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.





User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com