Hello!
I'm relatively new to Excel VBA but I am enjoying it immensely. I have a situation where I’d like to perform an action when a sheet becomes unprotected. For example, I have some hidden columns containing calculations that the user doesn’t need to see. However, when I unprotect the sheet to perform maintenance, I’d like those columns to automatically become visible. And then hide again when I choose to re-protect the sheet. Is that something I can program in VBA? Thanks much for any assistance.
I'm relatively new to Excel VBA but I am enjoying it immensely. I have a situation where I’d like to perform an action when a sheet becomes unprotected. For example, I have some hidden columns containing calculations that the user doesn’t need to see. However, when I unprotect the sheet to perform maintenance, I’d like those columns to automatically become visible. And then hide again when I choose to re-protect the sheet. Is that something I can program in VBA? Thanks much for any assistance.
