What are the reserved names for macros?

[Guest]

What do I call a macro so that it automatically runs when I close the
document? I have used AutoNew and AutoOpen in the past, so I presume that
there is a reserved name for a macro to run on close?

 

[Guest]

G'Day

Auto_Close or;
Private Sub Document_Close()
ThisDocument.Save
End Sub
in Excel
Workbook_BeforeClose

krakmup

 

[Tony Jollans]

AutoClose is the equivalent.

Auto macros do have their uses but they have been largely seperseded by
Events.

Open the ThisDocument module of your document (or template) ..
From the dropdown at the top left of the code window select Document
From the dropdown at the top right of the code window select Close

Put your code in the generated skeleton procedure.

 

[Guest]

Thanks, I am not really VBA "Compliant" as I record all my macros, I suppose
I will have to update that skill now!!!

Jane

 

[Tony Jollans]

Good Luck! It's well worth it!

--
Enjoy,
Tony

Thanks, I am not really VBA "Compliant" as I record all my macros, I suppose
I will have to update that skill now!!!

Jane