Forum Discussion

Robinsong's avatar
Robinsong
Copper Contributor
Nov 13, 2019

excel worksheet protection

I used to be able to protect multiple sheets in an Excel workbook by simply choosing the sheets, then protecting them.  Now I cannot do that any more!  MS removed this ability from Macs?!?   I have...
Excel on Mac
Robinsong's avatar
Robinsong
Copper Contributor
Nov 14, 2019

JKPieterse 

 

Yeah, there are a lot of features that disappeared in the most recent version.  It's very frustrating, especially since Microsoft originally wrote Excel for the Mac then later just kluged it to make it fit Windows.  I can understand that MS can't do all the things in Windows that they have done in Macs, but why get rid of these features in the Mac?!?  Just trying not to hurt Window's feelings?

 

Enough venting.  I use VBA, although I am not an expert.  Can you give me some info about a macro to lock down worksheets?

 

Thanks, Charlie

JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 15, 2019

Robinsong Simple enough:

Sub UnprotectAll()
    Dim Sh As Worksheet
    For Each Sh In Worksheets
        Sh.Unprotect PassWord:="drowssaP"
    Next
End Sub

 

Resources