Peo,

I tried your suggestion but it didn't help, I still get the dialogue box to
press "OK". Any other ideas?

"Peo Sjoblom" wrote:

Oops! Last but second line should be

Application.DisplayAlerts = True


Peo


"Peo Sjoblom" wrote in message
...
Sub MyMacro()
Application.DisplayAlerts = False
'your code here
Application.DisplayAlerts = False
End Sub


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Austin" wrote in message
...
I've written a macro that uses the histogram tool. When using the macro,
it
generates a dialogue box for "OK" to overwrite existing data which makes
me
hit enter on the keyboard. I just want it to continue without prompting
when
running the macro. I can't seem to find the magic to disable this. Any
thoughts from anyone. Help much appreciated. Thanks.

Tom