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

Thread: StartUp Macros

  1. #1
    Guest

    Default

    How do you set a macro to run automatically to initialize a spreadsheet. I want a spreadsheet to start the same everytime regarless of what was changed or entered.

  2. #2
    Guest

    Default

    Figured out my own issue.

    Right click the "little" spreadsheet symbol to the left of the File menu option and "View Code"



    In the WorkBook code sheet, select the "Open" sun or type Private Sub Workbook_Open()

    Then type
    Application.Run "WorkBookName.xls!MacroName"



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
  •