Forum Discussion
Mick_Kitcher
Aug 18, 2023Copper Contributor
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...
HansVogelaar
Aug 18, 2023MVP
See the attached workbook.
- The code is now in Module4 instead of in a worksheet module.
- It uses Worksheets("DATA") instead of DATA.
- It uses "Check Box 8" since that is the name of your check box.
Mick_Kitcher
Aug 18, 2023Copper Contributor
Hans, you're a star, thank you so much for getting me out of the dirt yet again, it's brilliant!!👏