How to execute a macro upon opening a document

K

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
 
L

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
 
Top