Run a macro on opening of workbook.

jimmywanna · Jan 14th, 2002, 02:18 PM

Can you make a macro run when you open a workbook. I need it to select a printer.

MrExcel · Apr 15th, 2002, 04:28 AM

Yes, on the ThisWorkbook object, put the code in the Workbook_Open module.

You want to somewhat follow the instructions in this tip:
http://www.mrexcel.com/tip055.shtml

but instead of putting the code in the Workbook_BeforePrint module, choose Open from the right dropdown above the Code window.

Bill

Apr 15th, 2002, 04:28 AM	#2
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	Yes, on the ThisWorkbook object, put the code in the Workbook_Open module. You want to somewhat follow the instructions in this tip: http://www.mrexcel.com/tip055.shtml but instead of putting the code in the Workbook_BeforePrint module, choose Open from the right dropdown above the Code window. Bill __________________ Preview my latest book for Free

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

Jan 14th, 2002, 02:18 PM	#1
jimmywanna Board Regular Join Date: Mar 2002 Posts: 182	Can you make a macro run when you open a workbook. I need it to select a printer.