Does anyone know what happens if Excel crashes, and reopens an autorecovered file? Does it fire the Workbook_Open? I have a goof amount of code that depends upon data integrity, which starts with some code in Worbook_Open. If I can figure out how to make it crash I could put a msgbox in to verify, but not sure how to force a crash.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
What happens if Excel crashes when a sheet is unprotected
- Thread starter indyman
- Start date
Jaafar Tribak
Well-known Member
- Joined
- Dec 5, 2002
- Messages
- 9,624
- Office Version
- 2016
- Platform
- Windows
Workbook_Open should fire when excel reopens an autorecovered file as long as macros are enabled.
To force a crash for testing, you could, for example, run the following CrashExcel SUB :
In a standard Module:
To force a crash for testing, you could, for example, run the following CrashExcel SUB :
In a standard Module:
VBA Code:
Option Explicit
#If VBA7 Then
Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As LongPtr)
#Else
Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long)
#End If
Sub CrashExcel()
CopyMemory Application, ByVal 0, 1
End Sub
Upvote
0
Solution
@Jaafar Tribak Thanks. That is good to know. I will test the crash some point in the future. And i fmacros are not enabled, the workbook will be useless - by design.
Upvote
0
