How to execute a macro upon opening a document

[Keith Brickey]

Can someone tell me how to make a macro automatically execute when a
document first opens? I also need to know how to change the setting found in
tools/options using VBA.

Thanks,

Keith

 

[Larry]

If you want this to work on just one particular document, insert in the
Document's project a macro called

Sub AutoOpen()

' put code here

End Sub