Filter highlighter
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
That's wonderful, Rory! Thank you very much, it looks great!
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 889
- Joined: 25 Jan 2010, 16:26
- Location: Garden Grove, CA 92844 USA
Re: Filter highlighter
How can I configure Excel 2007 such that this filter highlighter add-in is ALWAYS present and available? Even when starting new workbooks & sheets.
Don
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
Install it as an add-in:
Save the .xla or .xlam to a convenient folder, for example your Addins folder (C:\Users\<username>\AppData\Roaming\Microsoft\AddIns under Window Vista and Windows 7, or C:\Documents and Settings\<username>\Application Data\Microsoft\AddIns under Windows XP). But any folder will do.
In Excel 2007, click the Office button, then Excel options.
Click Add-Ins in the navigation pane on the left hand side.
Select Excel Add-ins from the Manage: dropdown at the bottom of the dialog (this is the default choice), then click Go...
If you see Filter Highlighter in the list of available add-ins, tick its check box.
Otherwise, click Browse..., navigate to the .xla / .xlam, select it and click OK. The add-in should now appear in the list; tick its check box.
Click OK.
The add-in should now be permanently available.
Save the .xla or .xlam to a convenient folder, for example your Addins folder (C:\Users\<username>\AppData\Roaming\Microsoft\AddIns under Window Vista and Windows 7, or C:\Documents and Settings\<username>\Application Data\Microsoft\AddIns under Windows XP). But any folder will do.
In Excel 2007, click the Office button, then Excel options.
Click Add-Ins in the navigation pane on the left hand side.
Select Excel Add-ins from the Manage: dropdown at the bottom of the dialog (this is the default choice), then click Go...
If you see Filter Highlighter in the list of available add-ins, tick its check box.
Otherwise, click Browse..., navigate to the .xla / .xlam, select it and click OK. The add-in should now appear in the list; tick its check box.
Click OK.
The add-in should now be permanently available.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 889
- Joined: 25 Jan 2010, 16:26
- Location: Garden Grove, CA 92844 USA
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: Filter highlighter
I just downloaded this and get an error at the line
Is this due to I have a 64bit system?
Code: Select all
Private Declare Function ChooseColor Lib "comdlg32.dll" Alias "ChooseColorA" (pColorStruct As ColorStruct) As Long
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
Change the line
to
and the lines
to
Code: Select all
Private Declare Function ChooseColor Lib "comdlg32.dll" Alias "ChooseColorA" (pColorStruct As ColorStruct) As Long
Code: Select all
Private Declare PtrSafe Function ChooseColor Lib "comdlg32.dll" Alias "ChooseColorA" (pColorStruct As ColorStruct) As LongPtr
Code: Select all
Private Type ColorStruct
lStructSize As Long
hwndOwner As Long
hInstance As Long
rgbResult As Long
lpCustColors As String
flags As Long
lCustData As Long
lpfnHook As Long
lpTemplateName As String
End Type
Code: Select all
Private Type ColorStruct
lStructSize As LongPtr
hwndOwner As LongPtr
hInstance As LongPtr
rgbResult As LongPtr
lpCustColors As String
flags As LongPtr
lCustData As LongPtr
lpfnHook As LongPtr
lpTemplateName As String
End Type
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: Filter highlighter
Thanks Hans, works great. Also, thanks to rory.
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
Does this work with 64bit version of Excel 2013?
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
On Excel 2013 64 bit I am getting the following compile error when clicking either choose highlight color or font.The filter heading will have a black cell color as well as black text as I cannot see the cell text. Could you help fix this error.
Thanks.
Thanks.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
Does it work if you change
Function ShowColor(...) As Long
to
Function ShowColor(...) As LongPtr
Function ShowColor(...) As Long
to
Function ShowColor(...) As LongPtr
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
The compile error moved to this area of the code
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
Does this version work? (By the way, I wonder why it worked for gailb and not for you...)
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Filter highlighter
And now?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Filter highlighter
It is working now. Your commitment to help is amazing. Thank you for your expertise and patience.