G grep Dec 22, 2004 #1 How do I set up a macro to start up when the spreadsheet opens? Can this be done in a template? Thanks, David
How do I set up a macro to start up when the spreadsheet opens? Can this be done in a template? Thanks, David
G Gord Dibben Dec 22, 2004 #2 grep Workbook_open() or Auto_open() sub. Private Sub Workbook_Open() 'do your stuff or call a macro End Sub Workbook_Open() sub would be placed into the ThisWorkbook module. Auto_Open() sub would be placed into a General module. Yes, it can be done in a Template. Gord Dibben Excel MVP
grep Workbook_open() or Auto_open() sub. Private Sub Workbook_Open() 'do your stuff or call a macro End Sub Workbook_Open() sub would be placed into the ThisWorkbook module. Auto_Open() sub would be placed into a General module. Yes, it can be done in a Template. Gord Dibben Excel MVP
