Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 160
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Execution C Brandt Excel Discussion (Misc queries) 2 July 13th 07 07:23 AM
Automatic execution of macro Paul-André Gollier Excel Programming 1 January 30th 04 09:03 PM
Template Macro Execution Nigel[_8_] Excel Programming 1 January 28th 04 03:10 PM
Screen off during Macro execution CLR Excel Programming 13 December 21st 03 06:04 AM
slow macro execution Vasile Dumitrescu Excel Programming 1 October 7th 03 03:31 PM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"