Run a macro when a workbook is opened

M

Mervyn Thomas

I know its there somewhere but I cannot find help on how to run a macro
which runs automatically when a workbook is opened and again how to run a
macro when a workbook is closed.
I can't figure out how to run open and close events!
Can anyone get me started?
 

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

Similar Threads

Need Help with Macro Security 1
Turning off automatic calculation 0
Opening a list of Excel files and run a macro in each 17
How to open multiple instances of Word 365? 5
Unwanted workbooks on startup 2
Hotkey in proper workbook 2
Slideshow with black border around it 0
closing another file by code causes failure to run workbook activate event 2

Top