excel toolbars

  • Thread starter Thread starter John
  • Start date Start date
J

John

when I open a spreadsheet (or for that matter a word file)
from an email, the "reviewing" toolbar opens
automatically, and similarly, opening a spreadsheet from
any hyperlink opens the "web" toolbar automatically. Is
there a way to prevent these toolbars from automatically
opening?
 
Jim Rech posted this today:

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

================

And for the web toolbar:
From a previous thread:
http://groups.google.com/[email protected]
 
Back
Top