Can you disable all popup/error messages?

[EssKayKay]

One more question if you please. Is it possible via VBA to disable all popup error messages?
Here's one that has me a bit annoyed.

Thanks,
Steve K.

 

[ranman256]

you can try this, but it may not stop THAT message.

usage: SetWarnings false

Private Sub SetWarnings(ByVal pbOn As Boolean)
   Application.DisplayAlerts = pbOn       'turn off sheet compatability msg
   Application.EnableEvents = pbOn
   Application.ScreenUpdating = pbOn
End Sub

 

[EssKayKay]

you can try this, but it may not stop THAT message.

usage: SetWarnings false

Private Sub SetWarnings(ByVal pbOn As Boolean)
   Application.DisplayAlerts = pbOn       'turn off sheet compatability msg
   Application.EnableEvents = pbOn
   Application.ScreenUpdating = pbOn
End Sub

OOPS – posted thread too soon.

Thanks RanMan for your quick response. I added your code into my worksheet but I am still receiving the error message. However, I may have inserted it in the wrong place or attempting to run in incorrectly. I’ll play with this a bit more.

Again, thanks

 

[ranman256]

you can just use:
Application.DisplayAlerts = FALSE

but that error may be too severe to be ignored by the command.

 

[EssKayKay]

you can just use:
Application.DisplayAlerts = FALSE

but that error may be too severe to be ignored by the command.

I tried that but I still see the message. My work-around is to first display my own MsgBox message briefly explaining what to do before the internal Excel message appears.

Thanks for your suggestion. Like I've stated before, you guys here are so helpful - much appreciated.