Reviewing toolbar always opens on one particular file
 

I have one excel file that automatically opens the reviewing toolbar when I
open the file. What can I do to turn this off? It only happens on one file,
there must be something I can do, but so far I haven't had any lucky finding
anything. Thanks!

Reviewing toolbar always opens on one particular file
 

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. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.


You have to save the workbook after deleting the custom properties.
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
"Cheryl" wrote in message
...
I have one excel file that automatically opens the reviewing toolbar when I
open the file. What can I do to turn this off? It only happens on one
file,
there must be something I can do, but so far I haven't had any lucky
finding
anything. Thanks!

Reviewing toolbar always opens on one particular file
 

Thanks for the advice, but if I have to click on an icon to run this macro, I
might as well just right-click and turn off the toolbar like I do everyday.
I was hoping to get rid of it all together. I've checked the properties too,
there is nothing there. That is what puzzles me about this one spreadsheet.
Thanks for the help though!

"Jim Rech" wrote:

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. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.


You have to save the workbook after deleting the custom properties.
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
"Cheryl" wrote in message
...
I have one excel file that automatically opens the reviewing toolbar when I
open the file. What can I do to turn this off? It only happens on one
file,
there must be something I can do, but so far I haven't had any lucky
finding
anything. Thanks!