outclassed
08-08-2007, 09:55 AM
Hi, sorry if this is a noob question, but Im having a problem displaying some userforms that I want to open when an excel file is open.
Anytime I show a userform in the Private Sub Workbook_Open() in ThisWorkbook I am automatically kicked to vba editor and everything starts up in debug mode with the yellow cursor on the call to show the userform.
These forms work fine when opened in the immediate box and this happens even when the userform is empty (just a default userform).
Do I just have some option on or something that is automatically kicking to debug mode?
If I try to step through the code I get this error
Run-Time error '400':
Application-defined or object-defined error
Thanks for reading, Drew.
Anytime I show a userform in the Private Sub Workbook_Open() in ThisWorkbook I am automatically kicked to vba editor and everything starts up in debug mode with the yellow cursor on the call to show the userform.
These forms work fine when opened in the immediate box and this happens even when the userform is empty (just a default userform).
Do I just have some option on or something that is automatically kicking to debug mode?
If I try to step through the code I get this error
Run-Time error '400':
Application-defined or object-defined error
Thanks for reading, Drew.