ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto run macro (https://www.excelbanter.com/excel-programming/322939-auto-run-macro.html)

John Garate

auto run macro
 
Excel 2002, Win XP, SP-2

I've prepared an excel template with a macro that imports data. I would like
the macro to run automatically when the worksheet opens. How can I do this?


--
John Garate




Tom Ogilvy

auto run macro
 
http://www.cpearson.com/excel/events.htm

see the Workbook_Open event.

--
Regards,
Tom Ogilvy

"John Garate" wrote in message
...
Excel 2002, Win XP, SP-2

I've prepared an excel template with a macro that imports data. I would

like
the macro to run automatically when the worksheet opens. How can I do

this?


--
John Garate







All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com