Hi
I have a strange problem. I have build a pretty lengthy macro attached to a userform of which worked fine until I added another page into it. Now when the macro starts up it usually works fine for the first three goes (meaning I open the userform and close it again), but the fourth or fifth time the workbook crashes before the userform is shown. The error message says "an error has occured and excel needs to close"?
I also tried to archive this workbook recently too and the problem seems to have been since then. Could this have changed something?. There is too much code to post.
Another theory is that I built this using one computer with excel 2002 and took the macro to another computer and added another page to the userform with excel 2003. Would this be a problem. The excel version differences didn't make any difference before I added the new page or tried to archive the workbook. Has anyone any idea if there is a known problem which may be causing this?
Thanks in advance.
Bookmarks