Run Macro when Excel opens

J

jaden78

Is there a way of having a macro run when Excel opens and another when
excel closes regardless of which workbook you are opening? I'm trying
to make is so users a prompted if the want to enable an Addin when
Excel opens and then automagically disable the macro when excel
closes. I know how to enable and disable the Addin, just not sure how
to do it on open and close.

I've been looking around the net a little and can't quite nail down
this answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top