circaa
11-08-2006, 01:06 PM
Hi
I have a button on my form that saves and closes the workbook. I did it like that :
Private Sub CommandButton5_Click()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub
But i get an error message when clicked, it's an excel message that says that excel has encountered an error and must close. The code of the error is 0xc0000005. I noticed that i get the error only when i made changes to the sheets of the workbook.
Can you help me out here
Joey
I have a button on my form that saves and closes the workbook. I did it like that :
Private Sub CommandButton5_Click()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub
But i get an error message when clicked, it's an excel message that says that excel has encountered an error and must close. The code of the error is 0xc0000005. I noticed that i get the error only when i made changes to the sheets of the workbook.
Can you help me out here
Joey