How to Turn Off the Warnings in VBScript

Written by alexander gokhfeld | 13/05/2017
How to Turn Off the Warnings in VBScript
Microsoft Office applications allows users to turn off VBScript warnings in Visual Basic scripts. (Chad Baker/Photodisc/Getty Images)

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


Application.DisplayAlerts = wdAlertsAll

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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.