Excel form navigation in macro

[hunt84]

Hi,

I'm using MS Excel 2000 and am stuck with a marco. I'm in the VB Editor and have two froms. One is a menu, the other is a form that i want to get to from the menu. I have command buttons on the forms and want these to be the means to get the user to go from one to the other and back. I have tried:

menu.Show

in the code and this works once but then when you try to go back to the origina menu there is an error because it is already open.

Any ideas?

Thank you

 

[dsi]

You should probably hide the active form before showing another. Then, to go back, hide the active form and show the other.

Form1 Command Button:
Form1.Hide
Form2.Show

Form2 Command Button:
Form2.Hide
Form1.Show