The LITErr object is the error handler for
SQL*XL. You can use it to control if error messages
are displayed or suppressed.
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
Temporarily switch off the error handler:
SQLXL.LITErr.DisplayAlerts = False
'Doing some work where no errors should be displayed SQLXL.LITErr.DisplayAlerts = True
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.