Auto Review Toolbar

[jeff]

Does anyone know how to turn off the auto reviewing
toolbar function? Whenever I open a spreadsheet from
someone else the toolbar automatically pops up. It
happens in both Excel and Word and I just want to turn it
off. Thanks.

 

[Jim Rech]

I get enough of these files, Dave, that I've added a button to my custom
toolbars to facilitate dealing with them. FWIW:

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

 

[Dave Peterson]

I've ammended my message for the reviewing toolbar:

Jim Rech posted this that might help:
http://groups.google.com/groups?threadm=OnF8mZ9tCHA.2124@TK2MSFTNGP12

And if you want a macro to clean this up, Jim posted this:
http://groups.google.com/[email protected]