toolbar changes on open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drabbacs@gmail.com - 22 Jun 2007 15:59 GMT

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

Reply to this Message

Bernie Deitrick - 22 Jun 2007 16:14 GMT

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

Signature

HTH,
Bernie
MS Excel MVP

>I work in an environment where passing workbooks to and from other
> people is a common occurence. Sometimes when opening up a workbook
[quoted text clipped - 7 lines]
> Thanks in advance
> drabbacs

Reply to this Message

drabbacs@gmail.com - 22 Jun 2007 16:36 GMT

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

On Jun 22, 11:14 am, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:

> From Jim Rech, Excel MVP:
>
[quoted text clipped - 36 lines]
> > Thanks in advance
> > drabbacs

Reply to this Message