Remove all occurences of a command bar button

[mikeburg]

Since I am still learning VBA, I sometimes my poor VBA creates too many command bar buttons that are identical when going between workbooks.

Can someone provide better VBA that will get rid of all occurances?

I have been using the following but hope there is something a little better to assure that all occurances of a particular command bar button is removed:

Please Login or Register  to view this content.

Thanks for your help. mikeburg

[Leith Ross]

Hello Mike,

It would help to see your workbook, since there are several variables that affect which solution should be used.

[mikerickson]

The general technique that I use is that immediatly before creating a command bar or a command bar control, I delete it (buffered by On Error Resume Next..Goto 0), or at least try to. That way there is never a duplicate.

[mikeburg]

That will work. Thanks a lot. mikeburg