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.

On Mar 23, 6:37 am, Graeme wrote:
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

I think Rob meant:

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


okrob wrote:

On Mar 23, 6:37 am, Graeme wrote:
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