Thread: Code Execution has been interrupted - ??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
  
Posts: 120
Default Code Execution has been interrupted - ??
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"

Reply With QuoteReply With Quote