auto run macro on opening excel

jamienwood · Apr 26th, 2002, 05:46 AM

I want a macro to automatically run when i open excel, the macro i want to run is one that hides the title bar i have that i just need to know where to put it or what code to write to auto run it

klb · Apr 26th, 2002, 05:55 AM

Record your macro and name it auto_open.

You can do the same thing with a macro to run when you close a workbook. Name it auto_close.

jamienwood · Apr 26th, 2002, 05:57 AM

thanx!!

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

Apr 26th, 2002, 05:46 AM	#1
jamienwood Board Regular Join Date: Apr 2002 Location: Manchester UK Posts: 133	I want a macro to automatically run when i open excel, the macro i want to run is one that hides the title bar i have that i just need to know where to put it or what code to write to auto run it

Apr 26th, 2002, 05:55 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Record your macro and name it auto_open. You can do the same thing with a macro to run when you close a workbook. Name it auto_close.

Apr 26th, 2002, 05:57 AM	#3
jamienwood Board Regular Join Date: Apr 2002 Location: Manchester UK Posts: 133	thanx!!