I have various buttons on a home tab which filter Sheet2 depending on which button is clicked. The filters hide columns on Sheet2, amongst other things.
Would it be possible to add some vba to the filter code which colours in a certain column header(s)?
For example here's my code for one of the buttons:
For the scenario above, I'd like S1, V1 and W1 changed from their current colour to orange, so it is clear for the user to understand which columns they need to fill in at which time.![]()
Please Login or Register to view this content.
I'd like the column headers to then revert to their old colour when a reset button is clicked... perhaps some reset colour code could be added to the below?:
Thanks in advance.![]()
Please Login or Register to view this content.
Bookmarks