Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workbook Open/Activate

    Hello,

    This may be a silly question, but which comes first Workbook_Open or Workbook_Activate?

    I have put a sort of password userform in the Workbook_Open event. Would it be better to put it in the Workbook_Activate event. If so why?

    This is Excel 2000/Win98

    Thanks,
    Michael Read

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Open/Activate

    Workbook Open occurs first. Where you put your code depends on what you want to accomplish. The Workbook Open event occurs only when the Workbook is opened. The Workbook Activate occurs after the Workbook Open event, but it also will occur every time the user switches to another workbook and then switches back to the one with the event code. Workbook Open will not occur when switching between Workbooks.
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Open/Activate

    Thanks!

Posting Permissions

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