Auto Open - Brother Label Printer

[Karin]

I have an AutoOpen macro attached to my Normal.dot. I installed a new
Brother label printer, and now the AutoOpen does not run automatically. If I
uninstall the printer, it runs fine. If I re-install the printer, it does
not run. I can force it to run, but I can't get it to run automatically.
Does anyone have any suggestions? (Brother is not too helpful.)

 

[Graham Mayor]

What does the macro do? Post the code.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Karin]

Sub AutoOpen()
'
' AutoOpen Macro
' Macro recorded 02/07/2007 by Karin Richardson
'
With ActiveWindow.view
.ShowRevisionsAndComments = False
.RevisionsView = wdRevisionsViewFinal

ActiveWindow.view.ShowHiddenText = True
Options.UpdateFieldsAtPrint = True
Application.TaskPanes(wdTaskPaneFormatting).Visible = True

End With
End Sub

 

[Graham Mayor]

I can't imagine what the Brother label printer contributes to this scenario,
though the macro itself could do with a tweak -

Sub AutoOpen()
With ActiveWindow.View
.ShowRevisionsAndComments = False
.RevisionsView = wdRevisionsViewFinal
.ShowHiddenText = True
End With
Options.UpdateFieldsAtPrint = True
Application.TaskPanes(wdTaskPaneFormatting).Visible = True
End Sub

I had a look on Brother's web site and there does not seem to be anything
unusual about their printer drivers (though I don't have the printer itself
to test). There is however an add-in for their P-Touch software and it is
more likely to be this that causes the problems.
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm should give you
some clues on how to have add-ins available only when you need them (albeit
the page is based on Acrobat's add-ins)


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Karin]

Graham, Thanks for the "tweak". I did find that if I open word, and then
open a blank document (which would come from normal.dot), the auto open does
not work. But if I close and save that new document when I re-open it, the
AutoOpen does work. Perhaps this is the way it works?

 

[Graham Mayor]

Yes - that is the way it works. You need an autonew macro if you want it to
act on new documents
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>