Auto save and close

  • Follow


Hi,
I have been using a simple Macro to save and close a workbook in Excel 2003 
without problems.
Sub cs()
'
'   Rem: Saves & closes sheet.

    ActiveWorkbook.Save
    ActiveWorkbook.Close
    
End Sub

After changing to Excel 2007 this Macro closes Excel after closing the 
workbook and I have tried various options to stop this without success. If I 
select and run the macro from the drop-down box it works, but when assigned 
to an auto shape it does not. Has anyone got an answer to this?
Frank.

0
Reply Utf 11/19/2009 10:50:03 AM


0 Replies
556 Views

(page loaded in 2.343 seconds)

Similiar Articles:
















7/22/2012 2:03:32 PM


Reply: