Code Execution has been interrupted - ??
Good thanks, very strange VBA sometimes
Tim Hull wrote:
I had this problem after hitting Control-Break during the execution of
a macro. Once it starts, it seems to (somewhat randomly) affect all
MS-Office macros.
The solution for me was very simple though: reboot the computer. (A
complete reboot was required - simply logging off was not sufficient).
The problem seems to have nothing to do with the macros themselves -
after rebooting, they're all working fine.
ina wrote:
in this part
'Application.DisplayAlerts = True ' here but if I comment goes to
dtmSave because dtmSave = 00:00:00
' ************
' Now + 7seconds + 30 seconds -- launch SAVEandEXIT and close PH
' ************
dtmSave = dtmTime + TimeValue("00:00:30") ' here
Application.OnTime dtmSave, "thisWorkBook.Save_Exit"
|