User Form Locks up Excel and must be restarted

B

Brian

I have User Form that seems to not want to play well with the others.

A week ago my code ran fine, but now when I try to open my user form, Excel
locks up and must be restarted. If I open the VBA Code window first before
trying to open the User form it runs fine.

I have not changed anything in my code, but it still locks up excel anyway.

Has anyone had this problem before?
 
R

Robert Flanagan

Try exporting the form, deleting it, and importing it back.

If that doesn't work, try deleting and recreating.

or put application.screenupdating = true if you have it set to false.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Crashes when trying to open a User Form 6
Excel locks up 2
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Access database "Locks Up" 1
Program locks up 1
Excel has caused an error in User.exe. 1
computer must be restarted 8
Excel hangs frequently 2

Top