Launch a macro on opening Excel file

MW · Apr 1st, 2002, 01:20 PM

How do I set a macro to run as soon as the Excel file is opened?

Thanks....

Ricky Morris · Apr 1st, 2002, 01:22 PM

Name your macro Auto_open() and it will be executed when the file is open.

Likewise, a macro named Auto_close() will be executed when the file is closed.

Ricky

Jack in the UK · Apr 1st, 2002, 03:37 PM

Hi
To add good call Ricky..

Always your fine Auto_Opens are for that shhet so Auto_Close will be needed to reverse this.

CAUTION...

Auto_Open that say removed toolbars will efect other open WkBks so be careful..

Close them and re open will be fine if reversed but can be a pain...

Apr 1st, 2002, 03:37 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi To add good call Ricky.. Always your fine Auto_Opens are for that shhet so Auto_Close will be needed to reverse this. CAUTION... Auto_Open that say removed toolbars will efect other open WkBks so be careful.. Close them and re open will be fine if reversed but can be a pain... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 01:20 PM	#1
MW New Member Join Date: Mar 2002 Posts: 3	How do I set a macro to run as soon as the Excel file is opened? Thanks....

Apr 1st, 2002, 01:22 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Name your macro Auto_open() and it will be executed when the file is open. Likewise, a macro named Auto_close() will be executed when the file is closed. Ricky