Auto Review Toolbar

  • Thread starter Thread starter jeff
  • Start date Start date
J

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.
 
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
 
Back
Top