I sent out large transactions files with filters for each office location to filter on their location.
Often times I turn filters on check pieces of information myself. Most times, I forge to turn them off before sending
The receipients then assume the filters are not on, and email me back asking where their location's data is. . .
So, the bulk of the change on the worksheet is changing the filter settings.
I have written a sub which goes through the filter row to highlight colors if any of the filters are turned on.
to find them very easily for me. . . to keep my customers happy. .
But the code isn't working quite right yet
What am i missing??
in module
thanks in advance!
sportsguy
Bookmarks