Thread: delete toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
drhalter drhalter is offline
external usenet poster
 
Posts: 39
Default delete toolbar

Sorry, seem to have figured it out:

set cmdbar = application.commandbars.add("MyBar")
with cmdbar
.protection = msoBarNoChangeVisible + msoBarNoCustomize
End with

Thanks again
Dave


"drhalter" wrote:

I have a button which creates, enables, and makes visible a toolbar. How do
I delete the toolbar when the user is done with it? I can make a toolbar
button that deletes the toolbar, but how do I do this if the user uses the
view menu or clicks the X in the corner of the toolbar to make it not
visible? So, if the toolbar exists, I would like it to be visible, if it is
not visible or made not visible, I don't want it to continue to exist. Any
ideas?

Thanks
Dave