Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: make macros execute automatically

    how do i make macros execute automatically when i open my excel file?
    thx

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067

    Re: make macros execute automatically

    Originally posted by jaime1985
    how do i make macros execute automatically when i open my excel file?
    thx
    Put them in the Workbook Open Event Handler or refrence them there
    to get to the workbook Code window right click on the image next to the File Menu item and Choose View Code. or Double Click on thisworkbook from the code editor menu and select workbook and open from the dropdown lists at the top of the screen.

    Hope this helps

    David

  3. #3
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21
    This also works....as I asked the same question a couple of weeks ago and got this anser from a different member:

    In the Project window of the VBA window, double-click This Workbook.

    Add the following:

    Private Sub Workbook_Open()
    Call Macro1' Or whatever your macro name is
    End Sub



    Melinda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •