Automatic Review Toolbar

K

Kevin Sprinkel

When my boss opens a file of mine off the network for
review, the subject toolbar displays automatically,
irritatingly. Can this automatic feature be turned off?
I couldn't find it in the Tools/Options or in Help.

TIA
Kevin Sprinkel
 
J

Jason Morin

You could use an Auto_Open macro that hides the toolbar
upon opening:

Sub Auto_Open()
Application.Toolbars("Reviewing").Visible = False
End Sub

Press Alt+F11, Insert > Module, and copy this code. Then
save the workbook.

HTH
Jason
Atlanta, GA
 
J

Jim Rech

The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review". There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

You can kill the added file properties manually or run the below macro to do
it. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.

If the toolbar pops up every time you start Excel then perhaps there is a
workbook in your XLSTART folder that is the cause.

--
Jim Rech
Excel MVP

Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentProperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = "_" Then _
x.Item(Counter).Delete
Next
CommandBars("Reviewing").Visible = False
End Sub
 
K

Kevin Sprinkel

-----Original Message-----
You could use an Auto_Open macro that hides the toolbar
upon opening:

Sub Auto_Open()
Application.Toolbars("Reviewing").Visible = False
End Sub

Press Alt+F11, Insert > Module, and copy this code. Then
save the workbook.

HTH
Jason
Atlanta, GA
Click to expand...

Thanks for your response, Jason.

I understand your code logic, but have the following
questions:

- when does an "Auto_Open" macro execute?
- would I have to attach this macro to each file I create,
or could it go in my boss' Personal worksheet?

Thank you.
Kevin Sprinkel
 
Top