toolbar changes on open

[drabbacs]

I work in an environment where passing workbooks to and from other
people is a common occurence. Sometimes when opening up a workbook
from someone else, my "reviewing" toolbar gets set to visible. I don't
want that to happen, I'll turn on the toolbar when *I* want it on,
thank-you very much.

Is it possible to always keep my personal toolbar configuration upon
opening someone else's workbooks?

Thanks in advance
drabbacs

 

[Bernie Deitrick]

From Jim Rech, Excel MVP:

***********************************
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.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
*********************************

 

[drabbacs]

Jim,

Thanks for the quick reply.

I'm more interested in a solution that will automatically prevent the
issue from occuring in the first place, meaning I don't want to have
to run a macro after the issue occurs. I want it not to occur.

My guess would be adding code someplace that overrides the custom
properties of a workbook on open. Since it would have to be common
across many books, I'm further guessing that it would be a module on
personal.xls or something similar. Or maybe there is a setting buried
someplace in Excel that says, "always use my toolbar configuration".

drabbacs