Want to disable revision toolbar

[Oliver]

If I open a document (Word / Excel XP), made by an other
user, the revision toolbar automatically shows up). I
don't want this. How to avoid this ?

 

[Graham Mayor]

I don't know enough about Excel to advise, but in Word, you can force it off
with a series of Auto macros, which work at different times as indicated

When starting Word

Sub AutoExec()
CommandBars("Reviewing").Visible = False
End Sub


When starting a new document

Sub Autonew()
ActiveWindow.View.Type = wdPrintView
'above line optional - forces print view
CommandBars("Reviewing").Visible = False
End Sub

When opening an existing document

Sub AutoOpen()
ActiveWindow.Caption = ActiveDocument.FullName
'above line optional - puts filename and path on title bar
CommandBars("Reviewing").Visible = False
Application.GoBack
'above line optional - puts cursor at last edit
End Sub

Use any or all of these as required. However, in practice, I find it more
convenient to have a button on a personal toolbar calling a macro to toggle
the display on or off - this code will run if applied to Excel also.

Sub ReviewToolbar()
With CommandBars("Reviewing")
..Visible = Not .Visible
End With
End Sub

See http://www.gmayor.dsl.pipex.com/installing_macro.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Charles Kenyon]

When they closed the document to send it to you, did it have the revision
toolbar open?
--
Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://www.addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://www.addbalance.com/usersguide/index.htm>

Word Resources Page
<URL: http://www.addbalance.com/word/wordwebresources.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.