Two more things. Change the Stop on Error mode in VBA tools - Options -
General - Error Stoppping. stop onj all errors. Also comment out all the ON
Error statements so you can find the source of the problem.

"hekske" wrote:

hi,

i have created a userform in excel. when i debug it it works fine. when i
click on the button "Save" (does a save as) and rename the file until here no
problem. but when i try to open the newly saved file it gives an error like
"excel has stopped working ....". when i place a messagebox just before the
form.show command, it displays the messagebox and when the command form.show
needs to be executed the error appears again and i can close excel. if i open
de file without executing the code and change something (for exemple add an
empty line) in the code and save it, the file works again. like this i can
not send this userform to be used by our offices.
what could be the problem????? has anyone got an idea?