Error when trying to Show Userform when Workbook Opens

[JeremyLearned]

Here’s my dilemma: I have a userform called frmLiabilityPlus that I want to show as soon as the workbook opens. In the workbook_open event I have the following code:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
frmLiabilityPlus.Show
<o> </o>
Now, if I run the code from the VBA editor window, it works fine.
<o> </o>
But, if I save the workbook and re-open, hopefully showing the userform, it blows up giving me errors on that line of code with messages saying, essentially, it can’t locate the form.
<o> </o>
<o>I even deleted all the code in userform_initialize to see if something there was something in it causing problems, but no luck.</o>
<o></o>
In some further testing, I added a button and a macro to the visible sheet. Activating the button runs the exact same code, and it runs fine that way.
<o> </o>
Any thoughts or ideas would be greatly appreciated!

 

[bertie]

Hi and welcome to the board.

...giving me errors on that line of code with messages saying, essentially, it can’t locate the form.

You need to Load the form into memory before you can show it.

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] Workbook_Open()
    Load frmLiabilityPlus
    frmLiabilityPlus.Show
[color=darkblue]End[/color] [color=darkblue]Sub[/color]