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

Vesa Hanhisalo
Vesa Hanhisalo used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

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

Author

Commented:
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