toolbars

  • Thread starter Thread starter George
  • Start date Start date
G

George

I want to create a worksheet that on open removes all the tool bars from
excel,
and to have a clean look.
I want to to use macro command for certain fonctionality such as print,
save.
 
hi,
without at lease 1 tool bar you are not going to run
macros. best to do what i did. create a custom tool bar
with the commands i use most then deactivate all other
tool bars.
 
Hi,
If you remove all the toolbars, this will affect all
workbooks, not just that one. You will need to use an
auto_close routine to reset commandbars (toolbars) on
closing otherwise you are in deep shookers.

- mark
 
Back
Top