CaptainGravyBum
New Member
- Joined
- Dec 1, 2023
- Messages
- 48
- Office Version
- 365
- Platform
- Windows
Happy New Year all!
I've had a few days away from the office and it appears my brain will not function anymore.
I have a simple excel checklist which when a row is complete it will conditionally format as green. I want the users to activate a macro when they are finished using the sheet and it will hide all rows that are green.
Trying to avoid using an autofilter because it can be removed too easily.
I know it's simple, but I'm not getting there fast.
Any help greatly appreciated.
I've had a few days away from the office and it appears my brain will not function anymore.
I have a simple excel checklist which when a row is complete it will conditionally format as green. I want the users to activate a macro when they are finished using the sheet and it will hide all rows that are green.
Trying to avoid using an autofilter because it can be removed too easily.
I know it's simple, but I'm not getting there fast.
Any help greatly appreciated.