Hi,
I have an driver activity worksheet with days of the week (Sun - Sat) arranged like this.
Mon
---
---
---
---
Tue
---
---
---
---
Wed
...
and so on. The weekdays are groups and expand and collapse with buttons for each day plus a "Show All" button. Works.
I have to protect it because the dimwits are modifying the worksheet to suit how they feel that particular day. Once they do, we can't read them programmatically.
I use
in Workbook_Open to open the current day. Also works fine.Please Login or Register to view this content.
When I add this to the weekday buttons (that collapse and expand the appropriate days)
It seems like the ActiveSheet.Protect gets executed before the rows have a chance to expand/collapse.Please Login or Register to view this content.
I can use the "Show All" button and ONE extra button, then all subsequent buttons don't execute. It's as if ActiveSheet.Unprotect isn't unprotecting.
Any takers?
Example attached:
Bookmarks