View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Preventing custom bars from appearing

I take it your workbook adds a custom toolbar in its open event. Include the
"Temporary:=True" argument in Commandbars.Add (see help), and/or in the wb's
close event delete the toolbar.

Regards,
Peter T

"Flint" wrote in message
...
When I open an Excel workbook there is always the last version of the

custom
toolbar I created. How do I prevent Excel from storing the toolbars from

the
workbooks I open, so that I don't have to delete them every single time?
Thanks.