disable Review toolbar which came up automatically when opening a.

C

ching.chiu

How can I disable the Review Toolbar which comes up automatically when
opening a file?
 
C

Celtic_Avenger

In the Workbook VBA actions.

The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.

Right Click and select "View Code"

There will be two drop down boxes one that will probably say General
if this has never been entered previously.

Change the box on the right to Workbook.

Then Change the right hand box to "Activate"

Insert the following code

Application.CommandBars("Reviewing").Visible = False

exit the VBA screen and then every time the file opens it will ensur
that the Reviewing Toolbar is not shown.

I hope this helps

Celtic_Avenger
:) :) :) :) :
 
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 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
 
Top