Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Execution Stopped
Is the code in the activeworkbook - the one being closed?
-- Regards, Tom Ogilvy "Phil Hageman" wrote in message ... Get a "Code execution has been interrupted" message when running this macro. Selecting Debug, the line ActiveWorkbook.Close is highlighted yellow. Could someone tell me what stops execution? Sub SaveAndClose() 'Saves and closes a Workbook Range("A1").Select ActiveWorkbook.Save ActiveWorkbook.Close End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Execution Stopped
Hi Tom
Thanks for your reply. The macro is in personal.xls, not the workbook being closed Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Execution | Excel Discussion (Misc queries) | |||
Automatic execution of macro | Excel Programming | |||
Template Macro Execution | Excel Programming | |||
Screen off during Macro execution | Excel Programming | |||
slow macro execution | Excel Programming |