Auto Review Toolbar

[Dave Peterson]

Jim Rech posted this that might help:

http://groups.google.com/groups?threadm=OnF8mZ9tCHA.2124%40TK2MSFTNGP12

jeff wrote:
>
> 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.

--

Dave Peterson
ec3...@msn.com

[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

--
Jim Rech
Excel MVP

[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%40TK2MSFTNGP12

And if you want a macro to clean this up, Jim posted this:
http://groups.google.com/groups?threadm=eJQbiTMYDHA.3444%40tk2msftngp13.phx.gbl

--

Dave Peterson
ec3...@msn.com