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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top