Hello,

I have written a macro to produce a new menu bar. However in some cases it
may already exist. I am struggling to write a pice of code that loops through
the current menu bars and identifies if a specific bar is already present.
Any Thoughts?

Many Thanks

Hi

You can do this before you create it


On Error Resume Next
Application.CommandBars("MyToolBar").Delete
On Error GoTo 0

' Your code that create the bar


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Neil Hopkinson" wrote in message
...
Hello,

I have written a macro to produce a new menu bar. However in some cases it
may already exist. I am struggling to write a pice of code that loops through
the current menu bars and identifies if a specific bar is already present.
Any Thoughts?

Many Thanks