Turing off warnings
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
|