Thread: Custom Toolbar
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default Custom Toolbar

The setup here is that I have a Custom Button on the Standard Toolbar that
when you click the custom button it opens custom toolbar "TBFiles".
"TBFiles" is a custom toolbar with 60 custom buttons grid, 12 rows by 5
columns, and because of that it is not something I want displayed all the
time. That is why I put the 1 custom button on the Standard Toolbar. I was
thinking there might be something I a missing in the ability to directly open
a toolbar by clicking a custom button without having to run code from a macro
in a file. If there is, then I would not see an excel file open and close
but would just see the toolbar "TBFiles" display nice and clean.

The best I have come up with is to just minimize the excel file that has the
macro that opens the custom toolbar "TBFiles". I do see a little blip of the
minimized excel header frame when opened but then the toolbar displays and
the little excel blip disappears. If there is not a way to do what I want
then this actually is not a bad way to do it.

Thank you for your follow-up repsonses.

Steven