Adding a macro that will work even when the sheet or workbook is protected (locked)

Something like:

'
' code
'
With Sheets("whatever")
       .Unprotect Password:="whatever"
       .Range("whatever").EntireRow.Insert
       .Protect  Password:="whatever"
End With
'
' code
'

Regards, TMS

Hi Will

Place this Code in ThisWorkbook Module...Code will run on Protected Sheets

Option Explicit

Private Sub Workbook_Open()
Dim wSht As Worksheet

 'set protection using UserInterface to allow macros to work
  For Each wSht In ActiveWorkbook.Sheets
        wSht.Protect _            
            DrawingObjects:=True, _
            Contents:=True, _
            Scenarios:=True, _
            UserInterfaceOnly:=True
         wSht.EnableSelection = xlUnlockedCells	
    Next wSht
End Sub

You're welcome...glad I could help. Thanks for the Rep.

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thanks for the rep.

Don't take that the wrong way!

What way would that be?

Not worried. Intrigued. I have no idea what a "Michael Buble style" is.

You know who Michael Buble is surely

He's a man. He's a singer. He's got a c r a p website. Can't really say I've seen or heard much of him. Probably wouldn't recognise him without subtitles or an introduction. I'm sure I've heard him sing but no idea, in all honesty, what he sounds like. My knowing nothing about him doesn't seem to have affected his fame.

So, like I said, no idea what a "Michael Buble style" might look or sound like. But the fact that I "shouldn't take it the wrong way" implies that I might, and I wouldn't like it


Regards, TMS

You clearly know more about him than I would want or need to. Won't ask why. Think we should probably draw a line now

Genuinely wasn't trying to offend!

I know. I was just messing ...

Have a good weekend. Regards, TMS