Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Excel => Topic started by: bbasujon on August 15, 2012, 05:38:45 PM

Title: Close a workbook using VBA in Microsoft Excel
Post by: bbasujon on August 15, 2012, 05:38:45 PM

If you just want to close a workbook without the user being prompted for any confirmations
about saving the workbook you can simply do this :

ActiveWorkbook.Close False
' closes the active workbook without saving any changes

ActiveWorkbook.Close True
' closes the active workbook and saves any changes

ActiveWorkbook.Close
' closes the active workbook and lets the user decide if
' changes are to be saved or not