K Keith Dec 3, 2004 #1 How can I get an Excel file to automatically run a macro whenever it is opened?
F Frank Kabel Dec 3, 2004 #2 Hi either rename your macro to Auto_Open() or put your code in the workbook_open event of your workbook module
Hi either rename your macro to Auto_Open() or put your code in the workbook_open event of your workbook module
T Tom Ogilvy Dec 3, 2004 #3 In addition: See Chip Pearson's page on events, particularly the workbook_Open event. (auto_open is similar, but an older form of events). http://www.cpearson.com/excel/events.htm
In addition: See Chip Pearson's page on events, particularly the workbook_Open event. (auto_open is similar, but an older form of events). http://www.cpearson.com/excel/events.htm
