Help !! Code Execution Breaks

L

leerem

Please Help, Yesterday everything was working fine, I turn my PC on today and
the code, whatever code i run breaks indescriminatly at points. I've changed
the keyboard and mouse thinking of a sticky key or something, to no avail.

No keys are being pressed while the code executes.

For Example

Sub Load Userform()
Userform.show

end sub

Userfom flashes up then disapears halting of the Userform.show line
(highlighted)
This is only one example the code stops everywhere, press continue is
carries on for a few lines then stops again.
I ran the same workbook on another PC and all is OK ! Whats Going On??

Help Please....
 
J

Joel

You break on error setting may have been changed in excel. the errors may
have always been there but the code was ignoring them. Check the following
menu from VBA

Tools - Options - General - Break on Error
 

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

Top