Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21

    Unanswered: Autostart Macro when workbook opens

    How do you tell a macro module to automatically run when the workbook is opened? I am doing a simple copy/paste special values before they are updated and would like the macro to run this without the user having to click on a macro button to run it everytime they open the workbook.

    Thank you,
    Melinda

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    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

  3. #3
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21
    Fantastic........Thank you!!!!!

Posting Permissions

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