DISCOVER
×

How to Turn Off the Warnings in VBScript

Updated April 17, 2017

Microsoft Visual Basic Scripting (VBScript) software is a simplified version of Visual Basic programming language. It allows users to create additional functions in their Windows applications, including Microsoft Office application programs, such as Word, Access and Excel. The Microsoft Office applications use Visual Basic for Applications module to run a VBScript in the user applications. By turning off the VBScript warnings in your Microsoft Office Excel applications that include VBA scripts you can speed up the editing of your Excel spreadsheets.

Click "Start" in Windows and then click "Microsoft Office Excel."

Click "File", select "Open" and then double-click on the spreadsheet file, in which you want to turn off VBScript warnings.

Click "Developer"on the menu and then click on the "Authoring" icon on the Excel toolbar.

Add the following code at the beginning of your VBA script:

Application.DisplayAlerts = wdAlertsNone

ActiveDocument.Close

Application.DisplayAlerts = wdAlertsAll

Click "File" and then click "Save" to turn off VBScript warnings in Microsoft Excel program.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Alexander Gokhfeld has been writing since 2002. He has written for the monthly business publications "AutoPublish" and "MGRealty." Gokhfeld holds certification in business intelligence infrastructure development as well as a Bachelor of Science in electric engineering from Urban Trans College.