Results 1 to 3 of 3

Thread: VBA - running a macro at worksheet load in Excel

  1. Oct 18th, 2002, 11:23 AM #1
    BobHayes
    BobHayes is offline

    Thread Starter
    New Member
    Join Date
    Oct 2002
    Posts
    3

    VBA - running a macro at worksheet load in Excel

    I have an Excel 2002 spreadsheet that does some automatic calculations when the user clicks on the command button. I would like the spreadsheet to run a particular macro when it first loads.

    I've tried putting code in Worksheet_Activate, but of course that doesn't run until the user selects the sheet. I don't want the user to have to do anything, I just want it to run automatically.

    Any suggestions? Thanks in advance.
    Reply With Quote Reply With Quote
  2. Oct 18th, 2002, 11:32 AM #2
    andreys
    andreys is offline
    Frenzied Member andreys's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,615
    Use Workbook_Open() instead.
    Reply With Quote Reply With Quote
  3. Oct 18th, 2002, 11:37 AM #3
    BobHayes
    BobHayes is offline

    Thread Starter
    New Member
    Join Date
    Oct 2002
    Posts
    3
    Originally posted by andreys
    Use Workbook_Open() instead.
    Well, duh.

    Thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width