StartUp Macros
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"



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
  •  

 

 
DMCA.com