View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KL[_6_] KL[_6_] is offline
external usenet poster
 
Posts: 18
Default Bulk-Delete All Custom Commandbars

Hi there,

Soppose I have bunch of files wich have quite a few different custom
commandbars (some are generated by code and some manually attached to the
file). The commandbar names may vary from file to file so it is difficult to
predict them. Is there a way to bulk-delete all CUSTOM commandbars without
having to specify their names?

Something like this:
For each cb in Application.CommandBars.CustomBars
cb.Delete
next cb

Also, is it possible in VBA to tell wheather a custom bar is attached to a
file?

Thanks,
KL