I have a workbook used by many people. I am trying to limit their access to a few cells on the first sheet.
There are macros triggered by worksheet_change events on that sheet. They "Advanced filter" rows, and hide columns with Custom Views. However, when I try to protect the sheet it breaks them (I protect them within the Workbook_Open macro). I was hoping that protecting with "userinterfaceonly=True" would solve the problem, but it appears I am wrong. If I unprotect they work again.
Is my only option to turn off/back on protection within the macro? I haven't found a very good description of what exactly userinterfaceonly does & doesn't allow.
Thanks for any help!
K
Bookmarks