Reviewing Toolbar

[Doug Yeung]

The reviewing toolbar pops up everytime I open a worksheet
that someone else sends me. How do I turn this auto-
opening function off? Any help is much appreciated!

[Robert Rosenberg]

One thing you could try is disabling the Reviewing Toolbar using the
following one line macro...

Sub DisableReviewingToolbar()
Application.CommandBars("Reviewing").Enabled = False
End Sub

Before doing so, consider creating a copy of the Reviewing toolbar (giving
it a similar name, like "Reviewing Custom") so that you don't lose the
features associated with comments and tracking. You can do this relatively
easy:

1. Click View-->Toolbars-->Reviewing to display the toolbar
2. Click Tools-->Customize...
3. On the Toolbars Tab, Click New...
4. Type a name for the toolbar (ex: Reviewing Custom) and Click OK
5. Hold the CTRL key and drag each button from the original Reviewing
toolbar to the newly created one.
Using the CTRL key will copy the button rather than move it.
Tip: To create a separator-thin vertical line between buttons-drag a
button slightly (about 1/4") to the right.
6. Hide both the toolbars and close the Customize dialog.
7. Run the above macro and exit Excel tosave the toolbar changes.

______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Doug Yeung" <yeun...@hotmail.com> wrote in message
news:1a1c01c2b789$bc449910$d3f82ecf@TK2MSFTNGXA10...

[Jim Rech]

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.

--
Jim Rech
Excel MVP