Can the Excel filter drop-down menu be manipulated in VBA?

Vesa Hanhisalo
Vesa Hanhisalo used Ask the Experts™
I had this question after viewing Modify default height of drop-down filter menu in Excel.

I manage an addin to Excel that I've created in vba. I'd like to add a custom option under the filter drop-down menu. On the referenced case the question was if the poup size could be set programmatically. Now I'm interested in adding a new custom option to the menu. Can the menu be manipulated in any way at all?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011
Sadly no, it is not exposed in VBA.
Vesa HanhisaloAutomation Designer


Thanks for help! It's bad news, but never blame the messenger.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial