Run a macro on opening of workbook.

[jimmywanna]

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

 

[MrExcel]

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