Hello team. Looking for help to secure/protect my attached workbook. The workbook, obviously, has macros all over the place.
What I am looking to happen is the following:
Main Tab: Hide all cells except for range D1:P60 when workbook open. Will also hide all other sheets unless admin logged in.
Allow selection of the following but prevent edits from other user other than admin (when logged in): Months in Arrow, M3:M11, the whole calendar D4:J58, row 60 (D:M), P5:P7, Admin Login button.
I have tried the protect/un-protect or locked/unlocked cells but I think I am doing it wrong. My macros would bug out when run on a protected sheet.