ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Supress Informational Error Messages (https://www.excelbanter.com/excel-programming/367668-supress-informational-error-messages.html)

JOUIOUI

Supress Informational Error Messages
 
I have used the SetWarnings = False in Access, but how would I supress the
informational error messages with VBA in Excel. I would like to put the code
in each of my macros since my users "freak out" when the soft edits appear.

I appreciate your help, thanks

Tom Ogilvy

Supress Informational Error Messages
 
possibly

Application.DisplayAlerts = False

--
Regards,
Tom Ogilvy


"JOUIOUI" wrote:

I have used the SetWarnings = False in Access, but how would I supress the
informational error messages with VBA in Excel. I would like to put the code
in each of my macros since my users "freak out" when the soft edits appear.

I appreciate your help, thanks


Graham Whitehead

Supress Informational Error Messages
 
could be as easy as: Application.DisplayAlerts = False

"JOUIOUI" wrote in message
...
I have used the SetWarnings = False in Access, but how would I supress the
informational error messages with VBA in Excel. I would like to put the
code
in each of my macros since my users "freak out" when the soft edits
appear.

I appreciate your help, thanks





All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com