Problem help asap!

[Ayral]

I created a user form on excel, I had it set to launch automatically with some buttons, that when clicked brings you to different sheets, but when it loads up the screen freezes and only lets you click the user form, except nothing happens! I cant close excel, and I cant access the VBA code to hide it, any help? please!
Ayral

 

[Teeroy]

The UserForm is modal so when it has the focus it must be hidden or closed to return control back to the code that called it.

If you want the form to stay open but still be able to access the worksheet underneath it then you should change the "ShowModal" property of the UserForm to False.

 

[Ayral]

I would do that, but I cant access the spreadsheet due to the modal property, is there a way to disable it using keys? it wont even let me go to file, or the vb editor

 

[Teeroy]

Try closing the UserForm using the X in the top right corner. If that doesn't work try Control+Break.

 

[Ayral]

Thank you!, ctrl + break worked! You just saved me starting again from a previous save :P

 

[Ayral]

Don't suppose you know why the buttons aren't working? this is the code for the 3:

Private Sub CommandButton12_Click()Sheets("New_Customer").Select
UserForm1.Hide
End Sub


Private Sub CommandButton13_Click()
Sheets("Main Menu").Select
UserForm1.Hide
End Sub


Private Sub CommandButton14_Click()
Sheets("New_Order").Select
UserForm1.Hide
End Sub

Thanks

 

[Teeroy]

I don't see why they wouldn't work (I'm assuming they are in the UserForm code module ).

Usually when something strange happens to me with a UserForm it is because an event has been triggered that I didn't think about. Do you have any Worksheet_Activate events on the sheets you are selecting that may be interfering with the code control flow?