Visual Basic Error Message

Mar 14th, 2002, 12:21 PM

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 · Mar 14th, 2002, 12:30 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 12:21 PM	#1
Guest Posts: n/a	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

Mar 14th, 2002, 12:30 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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."