Turing off warnings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often use the following in Access code to prevent msg's appearing when I'm
running a sequence.

DoCmd.SetWarnings False

Does anyone know if a similar bit of language works for Excel in VBA? I've
tried the above but Excel doesn't appaer to like it.

When I run the code I am copying data from several locations and it keeps
asking if I want to overright the existing data.

Any help appreciated.
 
I often use the following in Access code to prevent msg's appearing when I'm
running a sequence.

DoCmd.SetWarnings False

Does anyone know if a similar bit of language works for Excel in VBA? I've
tried the above but Excel doesn't appaer to like it.

When I run the code I am copying data from several locations and it keeps
asking if I want to overright the existing data.

Any help appreciated.
Click to expand...

DisplayAlerts = False

but when you're done with the code, be sure to turn it back on...

DisplayAlerts = True

Rob
 
I think Rob meant:

application.displayalerts = false
'....
application.displayalerts = true
 
Back
Top