Is there any way to have a macro start right when the excel spreadsheet is opened?
A Aaron Russell Aug 20, 2004 #1 Is there any way to have a macro start right when the excel spreadsheet is opened?
J JulieD Aug 20, 2004 #2 Hi Aaron yes, place the macro in the THISWORKBOOK module (rather than a normal module sheet) with the name Private Sub Workbook_Open() 'your code here End Sub Cheers JulieD PS Macros still have to be enabled for it to run
Hi Aaron yes, place the macro in the THISWORKBOOK module (rather than a normal module sheet) with the name Private Sub Workbook_Open() 'your code here End Sub Cheers JulieD PS Macros still have to be enabled for it to run
F Frank Kabel Aug 20, 2004 #3 Hi either name your macro Auto_open() or put your code in the workbook event procedure: Workbook_open()
Hi either name your macro Auto_open() or put your code in the workbook event procedure: Workbook_open()
