Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code execution has been interrupted | Excel Programming | |||
Code execution has been interrupted | Excel Programming | |||
Code execution has been interrupted | Excel Programming | |||
Code Execution has been Interrupted | Excel Programming | |||
Code Execution Has been Interrupted | Excel Programming |