Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto run macro Esradekan Excel Worksheet Functions 5 August 31st 08 11:58 PM
Sub Macro vrs Function Macro Auto Start Pat Excel Discussion (Misc queries) 7 June 6th 07 09:53 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
macro for auto sum ahemani New Users to Excel 2 July 29th 05 12:53 AM
macro auto run nightshift12 Excel Programming 3 June 7th 04 08:09 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"