Reviewing Toolbar

  • Thread starter Thread starter Toolbar Bob
  • Start date Start date
T

Toolbar Bob

I made a customized toolbar called Bob. That is the only
toolbar I want to have on excel. However, when I open
certain attached files, the toolbar "reviewing" shows
up. It is not all files.

Anyone know how to stop this?

Thanks,

Toolbar Bob
 
Thanks for the Macro. To confirm, I have to run the
Macro everytime the review toolbar shows up. I have two
more questions.

Is there a way to run it everytime a file opens? Running
a Macro (even putting a macro toolbar on my custom
toolbar) requires one step. Just closing the review
toolbar takes two.

Second, how can I have the orginator not have the review
toolbar come up. They may not know it is doing this.
How can I stop it at the source. Source is using Win2000
and XP

Thanks,

Toolbar Bob
 
If you run the macro when the Reviewing toolbar appears, it should clear
the custom file properties that triggered its appearance. The next time
you open the file, you shouldn't need to run the macro.

I don't know if there's any way for the originator to prevent the
toolbar from being activated -- in another post, Jim Rech wrote:
'================================
Subject: Re: Toolbar Troubles
Newsgroups: microsoft.public.excel.misc
Date: 2003-11-14 09:02:47 PST

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 want to kill it forever?

This seemed to work ok for me:

Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

Type this in and hit enter:
application.CommandBars("reviewing").Enabled = False

If you ever want it back, you can toggle it to true.

==
Another option that I saw on a word newsgroup that I thought was kind of neat
was to take ownership of the reviewing toolbar. Remove all the icons you don't
want and add all your favorites. And have it showing all the time.

====
If you really want a macro to run each time you open a workbook, you would need
an application event.

Chip Pearson has some nice notes at:
http://www.cpearson.com/excel/AppEvent.htm
 
Back
Top