Visual Basic Error Message

[Guest]

I have a macro and I load it into a button in the toolbar. However, when I click the button from other workbooks, I got an Visual Basic Error Message "400"
What should I do to solve this problem??
Thanks in advance

 

[Mudface]

Error 400 is defined as follows in the VB help:-

"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."