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

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

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

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

Post the code you have

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Austin" wrote in message
...
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

Here's the Macro code that is causing the popup OK prompt to overwrite
existing cells:
------------------------------------------------------------------------
Sub Sheets_Update()
'Histogram_Update Macro
'
Application.DisplayAlerts = False

Application.Run "ATPVBAEN.XLA!Histogram",
ActiveSheet.Range("$T$23:$T$2055") _
, ActiveSheet.Range("$AB$8"), , False, False, False, False
Application.Run "ATPVBAEN.XLA!Histogram",
ActiveSheet.Range("$B$8:$B$2055"), _
ActiveSheet.Range("$H$8"), , False, False, False, False

Application.DisplayAlerts = True
End Sub
-----------------------------------------------------------------------------------------------

"Peo Sjoblom" wrote:

Post the code you have

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Austin" wrote in message
...
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