how do I stop the reviewing toolbar from opening automatically?

F

Farfallabaci

How do I stop the reviewing toolbar from popping up automatically? It happens
in both Word and Excel (that I've noticed). It's a royal pain to have to
click on the toolbar each time to turn it off. Can't I just stop it from
showing up in the first place? I don't want to delete this toolbar, as it is
needed in some circumstances. But I also don't need it constantly popping up
every time!
[Using Word 2003 and Excel 2003 in XP]
Thanks!
 
B

Beth Melton

Here's an article that provides more information on "why" the toolbar
surfaces and a workaround to prevent it from occurring:

"Review Toolbar Annoyance"
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=221

Note if you do not want to completely disable the toolbar then use
this macros instead:

Sub AutoOpen()
With CommandBars("Reviewing")
.Visible = False
End With
End Sub

For Excel, an Auto_Open macro for all workbooks you open isn't as easy
as it is in Word. The easy route is to use the following macro to
disable the toolbar to prevent it from displaying.

Sub KillToolbar()
With CommandBars("Reviewing")
.Enabled = False
End With
End Sub

Then should you want to display it again use this macro:

Sub ReturnToolbar()
With CommandBars("Reviewing")
.Enabled = True
.Visible = True
End With
End Sub

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top