User Form Locks up Excel and must be restarted

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
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
 
Back
Top