I attached an example file.
I have a commandbutton that allows certain users access to hidden columns. However when the workbook is closed, just in case the users forget to "re-hide" those columns, I would like to have the specified columns automatically hide. There will be a sheet for every month of the year, so the VB code will have to check each sheet to make sure those specified columns are hidden before closing the workbook.
I'd like to protect each worksheet so that "regular" users can't alter it, but only can input data and insert comments.
In my example, columns AB:AC are the hidden columns that only management can view with a password. Cells B4:AA34 would be the data entry/insert comments cells. The commandbutton that unhides AB:AC is called "For Sups/Mgrs".
Please let me know if you have any questions and thanks in advance for your help!
test.xls
Bookmarks