How do you stop the Review toolbar from appearing at start-up

[Mark]

Does anyone know how to stop the Review toolbar from
appearing when starting up Excel 2002? Even when I remove
the toolbar from my View, it always pops up again as soon
as I open another spreadsheet. Any help is greatly
appreciated.

 

[Ron de Bruin]

Try this Mark

You can use this line to disable it
Application.CommandBars("Reviewing").Enabled = False
Set it 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.

 

[Debra Dalgleish]

Jim has also posted a macro that makes it easy to fix the problem:

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