toolbars

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.
 
G

Guest

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.
 
M

Mark

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
 
Top