review toolbar reappears
 

I searched but did not find this in a topic - so sorry if it has been asked
and answered.

I have a recurring issue where the Review Toolbar appears without me taking
any action. I don't know why, it just does.

I can't recreate a series of events that causes it.

Not a big issue, but really annoying.

Anyone have a solution?

Thanks,

Dave

If this appearing coincides with opening a 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.

Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentP*roperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = "_" Then _
x.Item(Counter).Delete
Next
CommandBars("Reviewing").Visib*le = False
End Sub

--
Jim
"dave" wrote in message
...
|I searched but did not find this in a topic - so sorry if it has been asked
| and answered.
|
| I have a recurring issue where the Review Toolbar appears without me
taking
| any action. I don't know why, it just does.
|
| I can't recreate a series of events that causes it.
|
| Not a big issue, but really annoying.
|
| Anyone have a solution?
|
| Thanks,
|
| Dave