Reviewing Toolbar Comes Up when I open certain files

[Francis Malinosky-Rummell]

I don't like the reviewing toolbar and have customized my
view and toolbars to my liking but whenever I open certain
spreadsheets the reviewing toolbar appears and stays there
for all future files and stays there if I open and close
excel. Why is there and how can I stop it.

Any help appreciated.

 

[Bob Flanagan]

Try putting the following in your personal.xls file:

sub auto_open()
commandbars("reviewing").enabled = false
end sub

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Bob Phillips]

You can get rid of it in the VBE immediate window with

Application.Commandbars("Reviewing").Enabled=False

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[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

 

[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 if you're familiar with macros. I keep this macro is in my Personal and
attached to a toolbar button.

--
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