"Reviewing" toolbar keeps showing up

K

Kevin

How can I permanently turn off the "Reviewing" Toolbar?

I go into Tools>Customize>Toolbars to turn it off, but
nearly every time I open Excel it reappears.

I want it always off unless I explicitly call for it. How
can I set this up?

TIA
 
R

Ron de Bruin

Hi Kevin

You can use this line to disable it
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again

Or check out this from Jim Rech

From: Jim Rech ([email protected])
Subject: Re: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing toolbar is triggered by
certain custom file properties. Go into File, Properties and the Custom
tab. There you will probably find several custom properties that begin with
underscores (as I recall). If you delete them and save the workbook and
close the Reviewing toolbar, I think the next time you open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted this:
http://groups.google.com/[email protected]
 

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