Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    50

    Unanswered: Newbie - autorun a macro?

    OK, I'm not really an Excel person, but I have created a macro that I want to run everytime the xls file is opened. Is there something like 'on startup' similar to Access?

    TIA,
    Joanne

  2. #2
    Join Date
    Jun 2008
    Posts
    50
    Never mind...found This Workbook/OnOpen

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    Sub Auto_OPen
    ...
    ...
    End Sub

    If you put this into a modules every time excel file open will exe it

    Sub Auto_Close
    ...
    ...
    End Sub

    will get run when the excel file is closed
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Jun 2008
    Posts
    50
    Thanks, MYLE

Posting Permissions

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