Excel 2003 Userform.Show error

[amotto11]

Hi All,

I have a problem that is not showing up in excel 2010 (my computer), but is showing up in excel 2003(co-workers computer).

Here is my code in ThisWorkbook

Please Login or Register  to view this content.

When i change the name of the "username" and run it on my computer i get the message box and click ok and the initial form shows just fine and i can push bottons and go from there. When i open the workbook on my co-workers computer (excel 2003), i see the message box then for some reason the VBA editor opens and so does the initial form, but the initial form does not do anything, no buttons work. When i go to the VBA Editor it looks as though something is running.... I am not sure what though, so i click the stop button then manually find the initial form and run it. Everything works good from there. I am not sure why the initial form is showing and not activating, also why is VBA Editor opening when i click ok on the message i have created. Thanks for all the help in advance.


Edit: I have even deleted the lines for my msgbox and the same thing is happening the intial form shows but it is not "active" for some reason, none of my buttons on it work. Does 2003 not allow the workbook_open() command in ThisWorkbook?

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[amotto11]

I was able to solve this because it wasn't anything in the code above it was an error in the Userform being called, the activate had code in it that was able to run in 2010 but not in 2003. I was able to solve this by putting messages in my userform activate code, because i always saw the userform it was just not activating. After moving the message down my code i was able to see why the userform was not activating.