How to Turn Off the Warnings in VBScript

Written by alexander gokhfeld
  • Share
  • Tweet
  • Share
  • Pin
  • Email
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.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

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

    Application.DisplayAlerts = wdAlertsNone

    ActiveDocument.Close

    Application.DisplayAlerts = wdAlertsAll

  5. 5

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

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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