close work book via macro

S

Sunil Patel

How do you suppress warnings when closing workbook
via macro i.e. do you want to save changes yes or no

thanks in anticipation
 
T

Trevor Shuttleworth

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Regards

Trevor
 
R

Ron de Bruin

Hi Sunil

ActiveWorkbook.Close SaveChanges:=False

or

ActiveWorkbook.Close SaveChanges:=true
 
M

mudraker

Workbooks("Name").Close SaveChanges:=True
or
Workbooks("Name").Close SaveChanges:=False


or

Application.DisplayAlerts = False
Workbooks("Name").Close
Application.DisplayAlerts = Tru
 
Top