Userform to Start When Workbook Opens

[JP777]

I have my userform coded to show when the workbook opens, but if another workbook is open, or even just the Excel application and no workbook, then when I open my program's workbook, the userform doesn't show up.....how can I fix this to where it always comes up when I open my program? Thanks

[royUK]

You need to attach the workbook. If it;s coded correctly you shouldn't have this problem

[JP777]

how do i attach the workbook?

[davesexcel]

how do i attach the workbook?

The same way you did it in your previous posts.

[JP777]

i have this in the This Workbook module:

Please Login or Register  to view this content.

This gets the userform to show up when I open the program and there is no other excel program running. If anything else with excel is running, the userform doesn't show up when opening my program. Where else do I need to attach it?

[john55]

hi, it should work even if you have another workbook opened. try to test yr UserForm adding a button (i.e in Sheet1)

Please Login or Register  to view this content.

[davesexcel]

You may have to use the Personal Macro Workbook.
And use code found here to work with any workbooks being opened.

Application Events In An Existing Object Module
Place this code in the personal macro workbook.
The code using the example from Chip's site will look like this.
Placed in the workbook module.

Please Login or Register  to view this content.

Save and exit from Excel.
Reopen excel and see what happens when you open workbooks.

Customize the code for your needs. You can also put UserForms in your Personal Macro Workbook.

[JP777]

I tried the code you provided after reading on the link you posted, and I used this as my code:

Please Login or Register  to view this content.

but I am still having the issue of the userform not showing up if I try to open the program when Excel is already running....Any other suggestions? Thanks for all the feedback!

[JosephP]

does your workbook actually open?

[davesexcel]

Did you follow my instructions and use the code provided to see how well that works before editing it?
Is the code in the Workbook module of the Personal Macro Workbook?
Are you familiar with the Personal Macro Wokbook?

[royUK]

You shouldn't need to use any different code. If the code is actually in the correct place & not typed into a module then it will run whenever it is opened with macros enabled. As I said attach the workbook so that we can see the code properly

[JP777]

JosephP, the workbook does actually open up with Excel running, just not the userform.

Dave, I will try the message box deal and see what happens

royUK, see the attached workbook for code.

[JosephP]

if you create another workbook with a blank form and set it to run on open, does it work if you already have Excel open?

[JP777]

yes, i tried to create another workbook, and it brought up the userform on open even when Excel was already open. I then tried on my program again. When the program is first opened, the userform will show up even if Excel is running. The problem comes after I close the program via the userform. after that, the userform doesn't show up on open with Excel running.

I apologize for my "moment" earlier in the post. I didn't realize royUK was telling me to attach my program when he told me to attach the workbook. I asked how to do it because I thought he was talking about some special linking process with vba.......

[JosephP]

one of the last lines of the form close code is

Please Login or Register  to view this content.

so it ain't too surprising that events won't run after that. ;-)

you need to set up a public boolean variable, set it to true in the form close code and then in the workbook_beforeclose event check if the variable is true and if so just exit without putting up your message.

[JP777]

that worked, JosephP, thanks!