On Sep 10, 10:58 am, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

Whilst the following suggestion won't change the selection, it may help
users to recognise that a filter has already been set. Although the small
arrow on the filter button turns blue when selection is on, this is hard to
see.

Debra Dalgleish has several downloadable example sheets on her site, where
the cell containing the heading becomes coloured if a filter is applied.
Users could be told that not more than one heading should be coloured for
their selection to be correct.

http://www.contextures.com/FilterColour.zip

--
Regards
Roger Govier

wrote in message

ps.com...



Hello,

I have an Excel 2003 file with 8 columns that one could filter on.
The AutoFilter function is set to ON. I have found that the users do
not always remember to click on (All) in the filter drop down menu
before moving to the next column and filtering...they end up with
narrowing down on their filter choices when all they wanted to do was
filter exclusively on the next column criteria.

With this dataset, there will never be a need to narrow down...Hence,
how do I make it so that if one moves to another column to filter, it
automatically sets everything back to (All)? There are way too many
users to train to select (All) every time they move to a different
column to filter on a different subject so a solution here would be of
great help!

Sargum- Hide quoted text -

- Show quoted text -

Hi Roger,

I like this suggestion a lot and have added the code...I right-clicked
and chose "View Code" and pasted. However, similar to Bernie's code,
nothing happened. Is there something else I am supposed to do after I
paste the code and close VB? I must be missing something here since
both yours and Bernie's code have not worked for me yet. I will play
around with it.

Sargum