Disable Toolbars... Permanently

[Justin Swall]

Every office has one - that one person that has to have
everything on their computer just so or they start to
pull their hair out.

One of the administrative assistants wants to show the
standard and formatting bars only in Microsoft Excel and
**never** wants any of the other bars to show unless
requested. Specifically, her reviewing toolbar opens
from time to time depending on what document she's
working on and she says that it "hinders her
productivity" and "wastes her time" to take the extra
second to right click on the bar and turn it off when she
uses Excel.

Anyone know how to force Excel not to open any other
toolbars under any circumstances other than specifically
requesting one? Thanks in advance.

 

[Dave Peterson]

You want to kill it forever?

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.

 

[Keith L]

To keep the Reviewing Toolbar from popping up when you
open files, choose Tools, Customize, Click the Toolbars
tab, highlight the Reviewing Toolbar (or whichever toolbar
you wish to keep from popping up), and press the Reset
button. You will lose any customizing you might have done
to that toolbar, but it shouldn't pop up automatically any
more (uncheck that toolbar too if it is checked).

Keith

 

[Dave Peterson]

That didn't work for me in xl2002.

To keep the Reviewing Toolbar from popping up when you
open files, choose Tools, Customize, Click the Toolbars
tab, highlight the Reviewing Toolbar (or whichever toolbar
you wish to keep from popping up), and press the Reset
button. You will lose any customizing you might have done
to that toolbar, but it shouldn't pop up automatically any
more (uncheck that toolbar too if it is checked).

Keith