I have some examples of commandbars on my website.

If you've set the Tag property on a control, you can use the .Find method of
Controls to find using Tag parameter.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Sophie" wrote in message
...
Hello Everyone!

A spreadsheet that I've used has set up a new drop down
menu at the top of my Excel application. (Like File, Edit
etc). Now I want to get rid of it.

I've had a good look through the postings on here and
can't find a way. I think I need to somehow list all
the ??msoControlDropdown?? options then delete the name
of the one I don't want. But everything on here seems to
refer to adding and deleting a specific name that you
already know!

If anyone could help I'd be very grateful

TIA

Sxx