Visual Basic Error 400

[kraljb]

I just upgraded from 2000 to 2003

I have quite a few macros that load up when I start excel, one of whic
is now causing an error message that just has a red circle with a whit
X in it and all it says is "400".

This was not happening before I upgraded. There are also some othe
issues with the code, but any direction with this error would b
helpful.

Thanks!
Joh

 

[Dave Peterson]

This is the error 400 description (from xl2002 VBA's help):

Form already displayed; can't show modally (Error 400)


You can't use the Show method to display a visible form as modal. This error has
the following cause and solution:

You tried to use Show, with the style argument set to 1 – vbModal, on an already
visible form.
Use either the Unload statement or the Hide method on the form before trying to
show it as a modal form.


=====
Are you using a userform when it blows up? Can you step through the code?