Results 1 to 3 of 3

Thread: Worksheet activate not called when starting workbook?[SOLVED]

  1. #1

    Thread Starter
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Worksheet activate not called when starting workbook?[SOLVED]

    Hi,
    I'm trying to show an Userform whenever a specific Worksheet is activated.
    That works fine if I activate this sheet coming from another one of this workbook.
    But the event is not called when opening the workbook, although the Sheet in question is shown . ?????
    What am I doing wrong?
    Last edited by opus; Mar 25th, 2003 at 01:43 AM.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

  2. #2
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    You're not doing anything wrong - it looks to be a bug with Excel.

    I've just created a messagebox to appear on the workbook's open event & it appeared after the worksheets were all created, so it looks like you could bypass the worksheet_activate event and use the following code in your case:
    VB Code:
    1. Private Sub Workbook_Open()
    2.     UserForm1.Show
    3. End Sub

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details

  3. #3

    Thread Starter
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863
    Thank'S Alex,
    I figured to the same "workaround"
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

Posting Permissions

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



Click Here to Expand Forum to Full Width