Your post breaks Rule 8 please click the link, read the rule and then amend you post accordingly.

new2excel · #1 (**permalink**) 7th February 2010, 06:05 AM

------ Register to get rid of these "In Post" ads! ------

I have been searching for a way to change the color of the autofilter button so it is more visible. I have found that can not be done. But there is a lot of code out there that will is said to change the color of the column head cell when it's filter is in effect. I have down loaded the zip files and opened the sample spread sheets and none have worked.

I am running Office Pro 2003, Excel 2003 (11.5612.5606) Can some one direct me to a sample that will work on my version of Excel so I can copy and past the code to my spread sheet?

I would really appreciate the help

Thanks

Simon Lloyd · #2 (**permalink**) 7th February 2010, 11:48 AM

------ Register to get rid of these "In Post" ads! ------

I'm not sure how to do that efficiently and maybe someone else will jump in however the following code will colour the first cell in a column if the autofilter is already being used:

VBA CODE:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
    If Me.AutoFilterMode = True And Me.FilterMode = True Then 
        Cells(1, Target.Column).Interior.ColorIndex = 3 
    Else 
        Cells(1, Target.Column).Interior.ColorIndex = xlNone 
    End If 
End Sub

new2excel · #3 (**permalink**) 7th February 2010, 06:59 PM

------ Register to get rid of these "In Post" ads! ------

I am brand new to VBA so I will need a little help getting through this.

I have created a spread sheet where column C is a column having 10 rows with numbers 1 - 10 in random order. The first data is in cell C3. The column header is cell C2 in which the autoformat has been set.

* I pressed alt-F11 to open VBA
* In project I select sheet1
* Pasted in the code.
* Save and close VBA

What do i do after that?

At Sample Excel Spreadsheets - Excel Templates there are a couple of zip files containing examples But I have not been able to make them work either. I think I must be doing the same thing wrong but I don't know what it is?

FL0014 - Colour Filter Headings -- Event code colours the filtered column headings, when an AutoFilter is applied. Updated to prevent unnecessary clearing of Undo stack, per tip from Nigel Hunt. FilterColour.zip 9 kb 15-Apr-05 updated 07-Dec-09

FL0007 - Highlight AutoFilter Headings -- User Defined Function, and conditional formatting, highlight column headings where filters are applied. FilterHighlight.zip 15kb

Change colour of Autofilter arrows
Change colour of Autofilter arrows - Excel Help & Excel Macro Help

Simon Lloyd · #4 (**permalink**) 7th February 2010, 07:31 PM

------ Register to get rid of these "In Post" ads! ------

You have been crossposting, we don't mind crossposting if it's done correctly, you will find that all the good people that answer questions visit ALL of the related forums so it doesn't go un noticed.

Attention

Your post breaks Rule 8 please click the link, read the rule and then amend you post accordingly.

A full list of rules (link shown in the terms and conditions you agreed to when joining) can be found here The Code Cage Forums - FAQ: Forum Rules , once you comply with the rule i will be happy to help further.

new2excel · #5 (**permalink**) 8th February 2010, 03:36 AM

------ Register to get rid of these "In Post" ads! ------

My apologies to the group. Newbee mistake I have cross posted
The Code Cage - Microsoft Office Help - Microsoft Office Discussion
Excel Help Forum

Simon Lloyd · #6 (**permalink**) 8th February 2010, 07:21 AM

------ Register to get rid of these "In Post" ads! ------

Thanks for those links but they need to be the url of the threads so that people can follow the progress

new2excel · #7 (**permalink**) 8th February 2010, 07:38 AM

------ Register to get rid of these "In Post" ads! ------

Quote:

Originally Posted by Simon Lloyd

Thanks for those links but they need to be the url of the threads so that people can follow the progress

Show what autofilter is in effect - Excel Help Forum

Simon Lloyd · #8 (**permalink**) 8th February 2010, 07:53 AM

------ Register to get rid of these "In Post" ads! ------

Thanks very much!

, in that case, try this:

VBA CODE:

CODE REMOVED WRONG THREAD

Simon Lloyd · #9 (**permalink**) 8th February 2010, 07:55 AM

------ Register to get rid of these "In Post" ads! ------

How did the solution at excel forum work for you?

new2excel · #10 (**permalink**) 9th February 2010, 03:53 AM

------ Register to get rid of these "In Post" ads! ------

Quote:

Originally Posted by Simon Lloyd

How did the solution at excel forum work for you?

I was able to get it working. It is more complex than i was thinking. I was hoping for something simple like changed the column header color when filtered. But it accomplishes the what i need.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)