run macro on close & open

[Stu]

How do i get a macro to run when a document is closed or opened?

Cheers

 

[Tom Ogilvy]

If the macro is in the workbook, the workbook must be open for the macro to
actually run. The true anwer would be specific to the context of how you
are trying to run a macro. For instance, if you assign a macro to the
onaction property of a commandbar button, then when the button is pushed, if
the workbook is closed, excel will open it and run the macro.

 

[Chip Pearson]

Stu,

If you mean to have a macro run when a specific workbook is opened, name
the macros Autpen and Auto_Close. If you mean to have a macro run when
any workbook is opened or closed, you need to use application-level events.
See www.cpearson.com/excel/appevent.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Tom Ogilvy]

Well that interpretation makes more sense <g>

--
Regards,
Tom Ogilvy

Stu,

If you mean to have a macro run when a specific workbook is opened, name
the macros Autpen and Auto_Close. If you mean to have a macro run when
any workbook is opened or closed, you need to use application-level events.
See www.cpearson.com/excel/appevent.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)