+ Reply to Thread
Results 1 to 4 of 4

Autorun a macro on Excel startup

  1. #1
    R Guzman
    Guest

    Autorun a macro on Excel startup

    Does anyone know how I can execute a macro to auto-start once I open up an
    Excel file?

    Thanks.



  2. #2
    Bondi
    Guest

    Re: Autorun a macro on Excel startup

    Hi,

    You can put this in your excel file:

    Private Sub Workbook_Open()
    [Your code here]
    End Sub

    Regards,
    Bondi


  3. #3
    Roger Govier
    Guest

    Re: Autorun a macro on Excel startup

    Hi

    If you name the macro Auto_open, then it will execute on opening the
    file

    Sub Auto_open()

    your code here

    End Sub

    --
    Regards

    Roger Govier


    "R Guzman" <[email protected]> wrote in message
    news:[email protected]...
    > Does anyone know how I can execute a macro to auto-start once I open
    > up an Excel file?
    >
    > Thanks.
    >




  4. #4
    R Guzman
    Guest

    Re: Autorun a macro on Excel startup

    Thanks everyone for your solution.

    Regards, R.

    "Roger Govier" <[email protected]> wrote in message
    news:[email protected]...
    > Hi
    >
    > If you name the macro Auto_open, then it will execute on opening the file
    >
    > Sub Auto_open()
    >
    > your code here
    >
    > End Sub
    >
    > --
    > Regards
    >
    > Roger Govier
    >
    >
    > "R Guzman" <[email protected]> wrote in message
    > news:[email protected]...
    >> Does anyone know how I can execute a macro to auto-start once I open up
    >> an Excel file?
    >>
    >> Thanks.
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1