Inconstant Toolbars

G

Guest

Sometimes I open Excel and the Reviewing toolbar is present. I remove it and do my work. Later when I start Excel it may or may not be there. I tried adding Picture toolbar and closing Excel; when I opened the next time it was still there. Is there some way to have Excel open (blank, empty worksheet) with only the toolbars I want, and not rember what was present the last time it closed? This is more help than I need, thank you Excel.
Word acts the same way. And Powerpoint. Evidently an Office "feature" that 3 or 4 people on the planet want, so we all have to waste time clicking away the toolbars so we can see our work.
How do I stop Office applications from doing this?
Thanks
 
D

Dave Peterson

Jim Rech posted a couple of techniques:

http://groups.google.com/[email protected]

And if you want to kill it forever, then this seemed to work ok for me:

Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

Type this in and hit enter:
application.CommandBars("reviewing").Enabled = False

If you ever want it back, you can toggle it to true.

Another option that I saw on a word newsgroup that I thought was kind of neat
was to take ownership of the reviewing toolbar. Remove all the icons you don't
want and add all your favorites. And have it showing all the time.
 

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

Top