Turing off warnings

[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.

 

[okrob]

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.

DisplayAlerts = False

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

DisplayAlerts = True

Rob

 

[Dave Peterson]

I think Rob meant:

application.displayalerts = false
'....
application.displayalerts = true