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.