Excel crashes after Application Wait

Diskutiere Excel crashes after Application Wait im Office Forum im Bereich Microsoft Community Fragen; After this Auto_open () makro ist stopped by hitting the ESC Key, it is not possible to edit the makro an save the worksheet manualy after...
M

MSCom

Neuer Benutzer
Threadstarter
Dabei seit
20.09.2016
Beiträge
1
After this Auto_open () makro ist stopped by hitting the ESC Key, it is not possible to edit the makro an save the worksheet manualy after stopping it.
The wait is needed in order to have the possiblity to interrupt the auto_open makro, in case to make some changes.

Or is there a workaround?


Extract from code:

Sub Auto_open()

Application.Wait (Now + TimeValue("0:00:05"))

... some makro steps

OpenAfterPublish:=False
Application.DisplayAlerts = False
ActiveWorkbook.Save

Application.Quit

End Sub
 
Thema:

Excel crashes after Application Wait

Excel crashes after Application Wait - Ähnliche Themen

Strange Excel behavior in some IF functions: Yesterday I was notified about the false calculation results in one of our interface files. After some research I came to the conclusion that the...
sheets.protect interrupts connections.refresh: Hello, I`m new in this community. I`ve already searched on diverse HPs without finding a solution. I really hope, someone here can help me. Using...
Excel VBA Code crashes PPT Presentation and lead to Error 462: Hallo, you guys are my lost hope. Nobody and nothing was able to help me so far, not google, not Stackoverflow, no other experts. I have a Code...
Excel VBA Code crashes PPT Presentation and leads to Error 462: Hallo, I have a Code, which starts in Excel and opens a PPT, updates the links, renames the PPT and closes it. The problem: Sometimes (not...
Surface Laptop 3 | Audio Latenz Probleme | Wdf01000.sys: Ich habe seit letzter Woche einen neuen Surface Laptop 3 und nutze die DJ-Software Native Instruments Traktor 3 zusammen mit dem Hardware DJ Mixer...
Oben