Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Solly
 
Posts: n/a
Default Running macros when Excel starts up

Hi

How do I get macros or some code to run automatically when I start up an
excel worksheet?

Thanks
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

I think you mean workbook, not sheet, correct? Open your workbook. Hit
Alt+F11 or Tools--Macro--Visual Basic Editor. Double-click ThisWorkbook on
the left below your Project's name. On the right, hit the first dropdown and
choose Workbook. You can choose other events on the right-hand dropdown, but
the Workbook_Open appears already, so just place your code between the
Private... and End Sub.
*******************
~Anne Troy

www.OfficeArticles.com


"Solly" wrote in message
...
Hi

How do I get macros or some code to run automatically when I start up an
excel worksheet?

Thanks



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
Running Excel events even in edit mode.... Ishika Excel Discussion (Misc queries) 0 June 16th 05 06:53 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
HELP - Running Macros in VBA Louise New Users to Excel 7 April 6th 05 03:21 PM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM


All times are GMT +1. The time now is 01:43 PM.

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

About Us

"It's about Microsoft Excel"