Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close work book via macro
How do you suppress warnings when closing workbook
via macro i.e. do you want to save changes yes or no thanks in anticipation |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
close work book via macro
Application.DisplayAlerts = False
' your code Application.DisplayAlerts = True Regards Trevor "Sunil Patel" wrote in message ... How do you suppress warnings when closing workbook via macro i.e. do you want to save changes yes or no thanks in anticipation |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
close work book via macro
Hi Sunil
ActiveWorkbook.Close SaveChanges:=False or ActiveWorkbook.Close SaveChanges:=true -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Sunil Patel" wrote in message ... How do you suppress warnings when closing workbook via macro i.e. do you want to save changes yes or no thanks in anticipation |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
close work book via macro
Workbooks("Name").Close SaveChanges:=True
or Workbooks("Name").Close SaveChanges:=False or Application.DisplayAlerts = False Workbooks("Name").Close Application.DisplayAlerts = Tru -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro shared work book | Excel Discussion (Misc queries) | |||
macro for work book | Charts and Charting in Excel | |||
I was messing arround with the VBA and now I get the macro warning when I open the work book but when... | New Users to Excel | |||
getting same save-on-close macro to work from different networklocations | Excel Programming | |||
getting same save-on-close macro to work from different networklocations | Excel Programming |