Save Excel workbook without being prompted
How to save an Excel workbook without being prompted using VBA
Sub Save_Workbook_with_no_prompt()
'disable the alerts being displayed
Application.DisplayAlerts = False
Application.DisplayAlerts = False
'save the workbook
ThisWorkbook.Save
ThisWorkbook.Save
'enable the alerts to be displayed again
Application.DisplayAlerts = True
Application.DisplayAlerts = True
End Sub
ADDITIONAL NOTES
Note 1: This code will save the workbook, without being prompted, in which the VBA code is written in.
Note 1: This code will save the workbook, without being prompted, in which the VBA code is written in.
EXPLANATION
This tutorial explains and provides step by step instructions on how to save an Excel workbook without being prompted using VBA.
The VBA code that is provided in this tutorial will save the workbook, without being prompted, in which the VBA code is written in.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Open an Excel workbook | How to open a single workbook using Excel, VBA and Shortcut methods | |
| Close an Excel workbook | How to close a single workbook using Excel, VBA and Shortcut methods | |
| Save an Excel workbook | How to save a workbook using Excel, VBA and Shortcut methods | |
| Open an Excel workbook as Read-Only | How to open a single workbook as Read-Only using Excel and VBA methods | |
| Save and close an Excel workbook | How to save and close a workbook using VBA |