|
-
Mar 24th, 2003, 08:48 AM
#1
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!
-
Mar 24th, 2003, 10:48 AM
#2
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:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
-
Mar 25th, 2003, 01:42 AM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|