Forum Discussion

Copper Contributor

Aug 18, 2023

Protect/Unprotect Sheet with a checkbox

Can anyone help please, CHAT GPT can't!! I'm trying to record a macro to Protect/Unprotect a single sheet using a Checkbox in Excel 365 for Mac but am unable to mage it. All suggestions warmly welc...

Macros and VBA

HansVogelaar

MVP

Aug 18, 2023

Mick_Kitcher

Does the attached workbook work on a Mac? The macro assigned to the check box is:

Sub CheckBox1_Click()
    With Sheet1
        If .Shapes("Check Box 1").ControlFormat.Value = 1 Then
            .Protect ' Password:=:"Secret"
        Else
            .Unprotect ' Password:="Secret"
        End If
    End With
End Sub

Since it is a macro-enabled workbook, make sure that you allow macros when you open it.