Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Autorun a macro

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone tell me if it's possible to run a user-created macro automatically when a workbook is opened?

    THANKS!!

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Ireland
    Posts
    107
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah think so. when u open VBA click on thisworkbook and then choose the open property and set the macro to run within the function
    [Brian]

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-13 07:16, jamesgw wrote:
    Can anyone tell me if it's possible to run a user-created macro automatically when a workbook is opened?

    THANKS!!
    Placed in the Thisworkbook object
    Alt + F11
    Ctrl + R
    Double click on Thisworkbook
    Paste this code in.


    Private Sub Workbook_Open()
    Call YourMacroNameGoesHere
    End Sub



    _________________
    Kind Regards,
    Ivan F Moala
    Have a Nice day

    [ This Message was edited by: Ivan F Moala on 2002-05-13 07:22 ]

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks eddd82 and Ivan. That seemed to work!!

    NOW, ...

    CAN YOU TELL ME what command can I put in the open workbook macro that will accept "ENABLE MACROS"?

  5. #5
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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