G Guest Jan 17, 2006 #1 I was wondering if there is a way I can have a macro run automatically everytime I open the excel workbook I put the macro in.
I was wondering if there is a way I can have a macro run automatically everytime I open the excel workbook I put the macro in.
G Guest Jan 17, 2006 #2 Yes. Say you called your macro 'MyMacro'. In the Workbook_Open event of the 'ThisWorkbook' module, call your macro. HTH,
Yes. Say you called your macro 'MyMacro'. In the Workbook_Open event of the 'ThisWorkbook' module, call your macro. HTH,
N Norman Jones Jan 17, 2006 #3 Hi WannaBe, Any code you place in the workbook's Workbook_Open or Auto_Open procedures will run when the workbook is opened. For information on these event procedures see David Mcritchie's Events page at: http://www.mvps.org/dmcritchie/excel/event.htm For an in depth discussion of Event procedures see Chip Pearson's Events page at: http://www.cpearson.com/excel/events.htm
Hi WannaBe, Any code you place in the workbook's Workbook_Open or Auto_Open procedures will run when the workbook is opened. For information on these event procedures see David Mcritchie's Events page at: http://www.mvps.org/dmcritchie/excel/event.htm For an in depth discussion of Event procedures see Chip Pearson's Events page at: http://www.cpearson.com/excel/events.htm
G Guest Jan 18, 2006 #5 Thank you very much guys. I put your ideas together and I was able to solve my problem. Thanks once again.
Thank you very much guys. I put your ideas together and I was able to solve my problem. Thanks once again.
