LITErr Object
SQL*XL
home
SQLXL    
  LITErr  

Description:

The LITErr object is the error handler for SQL*XL. You can use it to control if error messages are displayed or suppressed. 

Properties:

Name Data Type Description
DisplayAlerts As Boolean If set to False, SQL*XL will not display any alert, warning or error message. Default value is True. The logging of error messages in the event log is not affected by this setting.

Example:

Temporarily switch off the error handler:

SQLXL.LITErr.DisplayAlerts = False
'Doing some work where no errors should be displayed
SQLXL.LITErr.DisplayAlerts = True