Back to FAQ List

The following is a response on this topic from Jim Rech, Excel MVP.

---

Often, when a spreadsheet is opened, the reviewing toolbar shows up. How can this be avoided, permanently?

The Reviewing toolbar in Excel pops up whenever you open a workbook that has been emailed from within Excel "for review". There may also be other circumstances that cause this. If you do a File, Properties you'll see the custom file properties that have been added that triggers this.

The added file properties can be manually removed, or the following macro will also do it. This macro is in my Personal.xls, which is attached to a toolbar button (to provide an immediate response to the appearance of this toolbar).

Sub KillReviewingCustProps()
Dim oProp As DocumentProperties
Dim Counter As Integer
    Set oProp = ActiveWorkbook.CustomDocumentProperties
    For Counter = oProp.Count To 1 Step -1
        If Left(oProp.Item(Counter).Name, 1) = "_" Then _
          oProp.Item(Counter).Delete
    Next
    CommandBars("Reviewing").Visible = False
End Sub
			

Back to FAQ List