You're welcome, post back the final code so others can learn as well.


Thx,
JP


On Mar 2, 6:54*pm, "Greg B" <browgregory(NO wrote:
Thanks for that, I never noticed the extra menu item.

Greg"JP" wrote in message

...
Download CommandBar Tools from the link on that page. Unzip the file
and extract the XLA file to your destination of choice. Double click
on the file and make sure you enable macros if prompted. It adds a
menu to the toolbar on top called "EDC Tools" you would click on that
and select "List all commandbar controls". Then you can simply search
for the control you are trying to automate.

HTH,
JP