I am currently building a tool that incorporates a variety of macros. These range from simple macros to the more complex and include setting full screen and focus, disabling buttons and changing displayed images based on access levels stored on worksheets, putting password prompts on userforms to access other userforms, etc.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
However, I seem to have an issue where excel crashes frequently, at least twice per hour, I’ve tried re-installing Microsoft Office and Windows but the problem still persists. It is also happening on other machines.<o></o>
It frequently happens when trying to save the file, and comes up with the following error message:<o></o>
Problem signature:<o></o>
Problem Event Name: APPCRASH<o></o>
Application Name: EXCEL.EXE<o></o>
Application Version: 12.0.4518.1014<o></o>
Application Timestamp: 45428263<o></o>
Fault Module Name: VBE6.DLL<o></o>
Fault Module Version: 6.5.10.20<o></o>
Fault Module Timestamp: 45187577<o></o>
Exception Code: c0000005<o></o>
Exception Offset: 00111497<o></o>
OS Version: 6.1.7600.2.0.0.256.48<o></o>
Locale ID: 2057<o></o>
<o></o>
Additional information about the problem:<o></o>
LCID: 1033<o></o>
Brand: Office12Crash<o></o>
skulcid: 1033<o></o>
<o></o>
It also crashes when I am initiating or editing userforms, this is normally when I have changed the VB code (and crashes both when accessing particular forms or modules and on the worksheets). A common message is ‘Object not found.’ When I click on debug it displays the module that calls the userform and highlights the line ‘Userform1.Show’, which is in fact there and works previously.<o></o>
The Workbook has to go out to a client who will only have limited access to the worksheet and will not be able to edit the VBA code. I’m guessing it must be an error in part of the code that is causing the worksheet to crash but I’m not sure what to look for, as all the code seems to work but it just crashes at random intervals. If anyone could suggest what could be causing this and what I should be looking for it would be greatly appreciated.<o></o>
Many Thanks,<o></o>
Chris<o></o>
However, I seem to have an issue where excel crashes frequently, at least twice per hour, I’ve tried re-installing Microsoft Office and Windows but the problem still persists. It is also happening on other machines.<o></o>
It frequently happens when trying to save the file, and comes up with the following error message:<o></o>
Problem signature:<o></o>
Problem Event Name: APPCRASH<o></o>
Application Name: EXCEL.EXE<o></o>
Application Version: 12.0.4518.1014<o></o>
Application Timestamp: 45428263<o></o>
Fault Module Name: VBE6.DLL<o></o>
Fault Module Version: 6.5.10.20<o></o>
Fault Module Timestamp: 45187577<o></o>
Exception Code: c0000005<o></o>
Exception Offset: 00111497<o></o>
OS Version: 6.1.7600.2.0.0.256.48<o></o>
Locale ID: 2057<o></o>
<o></o>
Additional information about the problem:<o></o>
LCID: 1033<o></o>
Brand: Office12Crash<o></o>
skulcid: 1033<o></o>
<o></o>
It also crashes when I am initiating or editing userforms, this is normally when I have changed the VB code (and crashes both when accessing particular forms or modules and on the worksheets). A common message is ‘Object not found.’ When I click on debug it displays the module that calls the userform and highlights the line ‘Userform1.Show’, which is in fact there and works previously.<o></o>
The Workbook has to go out to a client who will only have limited access to the worksheet and will not be able to edit the VBA code. I’m guessing it must be an error in part of the code that is causing the worksheet to crash but I’m not sure what to look for, as all the code seems to work but it just crashes at random intervals. If anyone could suggest what could be causing this and what I should be looking for it would be greatly appreciated.<o></o>
Many Thanks,<o></o>
Chris<o></o>