I've written a macro that uses the histogram tool. When using the macro, it
generates a dialogue box for quot;OKquot; 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
nwexcelsolutions.comquot;Austinquot; gt; wrote in message
...
gt; I've written a macro that uses the histogram tool. When using the macro,
gt; it
gt; generates a dialogue box for quot;OKquot; to overwrite existing data which makes
gt; me
gt; hit enter on the keyboard. I just want it to continue without prompting
gt; when
gt; running the macro. I can't seem to find the magic to disable this. Any
gt; thoughts from anyone. Help much appreciated. Thanks.
gt;
gt; Tom
Oops! Last but second line should be
Application.DisplayAlerts = TruePeoquot;Peo Sjoblomquot; gt; wrote in message
...
gt; Sub MyMacro()
gt; Application.DisplayAlerts = False
gt; 'your code here
gt; Application.DisplayAlerts = False
gt; End Sub
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Austinquot; gt; wrote in message
gt; ...
gt;gt; I've written a macro that uses the histogram tool. When using the macro,
gt;gt; it
gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which makes
gt;gt; me
gt;gt; hit enter on the keyboard. I just want it to continue without prompting
gt;gt; when
gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt;gt;
gt;gt; Tom
gt;
gt;
Peo,
I tried your suggestion but it didn't help, I still get the dialogue box to
press quot;OKquot;. Any other ideas?
quot;Peo Sjoblomquot; wrote:
gt; Oops! Last but second line should be
gt;
gt; Application.DisplayAlerts = True
gt;
gt;
gt; Peo
gt;
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt; gt; Sub MyMacro()
gt; gt; Application.DisplayAlerts = False
gt; gt; 'your code here
gt; gt; Application.DisplayAlerts = False
gt; gt; End Sub
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; nwexcelsolutions.com
gt; gt;
gt; gt;
gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; I've written a macro that uses the histogram tool. When using the macro,
gt; gt;gt; it
gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which makes
gt; gt;gt; me
gt; gt;gt; hit enter on the keyboard. I just want it to continue without prompting
gt; gt;gt; when
gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt; gt;gt;
gt; gt;gt; Tom
gt; gt;
gt; gt;
gt;
gt;
gt;
Post the code you have
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Austinquot; gt; wrote in message
...
gt; Peo,
gt;
gt; I tried your suggestion but it didn't help, I still get the dialogue box
gt; to
gt; press quot;OKquot;. Any other ideas?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Oops! Last but second line should be
gt;gt;
gt;gt; Application.DisplayAlerts = True
gt;gt;
gt;gt;
gt;gt; Peo
gt;gt;
gt;gt;
gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Sub MyMacro()
gt;gt; gt; Application.DisplayAlerts = False
gt;gt; gt; 'your code here
gt;gt; gt; Application.DisplayAlerts = False
gt;gt; gt; End Sub
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Regards,
gt;gt; gt;
gt;gt; gt; Peo Sjoblom
gt;gt; gt;
gt;gt; gt; nwexcelsolutions.com
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Austinquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; I've written a macro that uses the histogram tool. When using the
gt;gt; gt;gt; macro,
gt;gt; gt;gt; it
gt;gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which
gt;gt; gt;gt; makes
gt;gt; gt;gt; me
gt;gt; gt;gt; hit enter on the keyboard. I just want it to continue without
gt;gt; gt;gt; prompting
gt;gt; gt;gt; when
gt;gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt;gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt;gt; gt;gt;
gt;gt; gt;gt; Tom
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
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 quot;ATPVBAEN.XLA!Histogramquot;,
ActiveSheet.Range(quot;$T$23:$T$2055quot;) _
, ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
Application.DisplayAlerts = True
End Sub
-----------------------------------------------------------------------------------------------
quot;Peo Sjoblomquot; wrote:
gt; Post the code you have
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Austinquot; gt; wrote in message
gt; ...
gt; gt; Peo,
gt; gt;
gt; gt; I tried your suggestion but it didn't help, I still get the dialogue box
gt; gt; to
gt; gt; press quot;OKquot;. Any other ideas?
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; Oops! Last but second line should be
gt; gt;gt;
gt; gt;gt; Application.DisplayAlerts = True
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; Peo
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Sub MyMacro()
gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt;gt; gt; 'your code here
gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt;gt; gt; End Sub
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt;
gt; gt;gt; gt; Regards,
gt; gt;gt; gt;
gt; gt;gt; gt; Peo Sjoblom
gt; gt;gt; gt;
gt; gt;gt; gt; nwexcelsolutions.com
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Austinquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt;gt; I've written a macro that uses the histogram tool. When using the
gt; gt;gt; gt;gt; macro,
gt; gt;gt; gt;gt; it
gt; gt;gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which
gt; gt;gt; gt;gt; makes
gt; gt;gt; gt;gt; me
gt; gt;gt; gt;gt; hit enter on the keyboard. I just want it to continue without
gt; gt;gt; gt;gt; prompting
gt; gt;gt; gt;gt; when
gt; gt;gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt; gt;gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Tom
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;
Sometimes, there's code that turn the alerts back on--and you have no control
over that code.
If you only get the popup once, then I'm guessing that the histogram turns
alerts back on and the second call is causing the trouble.
If you're getting that popup twice (one time for each call), then there must be
something in the Histogram routine that turns it on -- even if you dislike it.
I'd try this (Untested):
application.displayalerts = false
Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
ActiveSheet.Range(quot;$T$23:$T$2055quot;), _
ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
application.displayalerts = false 'turn it off once more
Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
application.displayalerts = true 'probably unnecessary if Histogram does it!It may not help, but it can't hurt to try.Austin wrote:
gt;
gt; Here's the Macro code that is causing the popup OK prompt to overwrite
gt; existing cells:
gt; ------------------------------------------------------------------------
gt; Sub Sheets_Update()
gt; 'Histogram_Update Macro
gt; '
gt; Application.DisplayAlerts = False
gt;
gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; ActiveSheet.Range(quot;$T$23:$T$2055quot;) _
gt; , ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
gt; ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
gt;
gt; Application.DisplayAlerts = True
gt; End Sub
gt; -----------------------------------------------------------------------------------------------
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Post the code you have
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Excel 95 - Excel 2007
gt; gt; Northwest Excel Solutions
gt; gt; www.nwexcelsolutions.com
gt; gt; quot;It is a good thing to follow the first law of holes;
gt; gt; if you are in one stop digging.quot; Lord Healey
gt; gt;
gt; gt;
gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Peo,
gt; gt; gt;
gt; gt; gt; I tried your suggestion but it didn't help, I still get the dialogue box
gt; gt; gt; to
gt; gt; gt; press quot;OKquot;. Any other ideas?
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; Oops! Last but second line should be
gt; gt; gt;gt;
gt; gt; gt;gt; Application.DisplayAlerts = True
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt; Peo
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt; Sub MyMacro()
gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt;gt; gt; 'your code here
gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt;gt; gt; End Sub
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; --
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Regards,
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Peo Sjoblom
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; nwexcelsolutions.com
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; gt;gt; gt; ...
gt; gt; gt;gt; gt;gt; I've written a macro that uses the histogram tool. When using the
gt; gt; gt;gt; gt;gt; macro,
gt; gt; gt;gt; gt;gt; it
gt; gt; gt;gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which
gt; gt; gt;gt; gt;gt; makes
gt; gt; gt;gt; gt;gt; me
gt; gt; gt;gt; gt;gt; hit enter on the keyboard. I just want it to continue without
gt; gt; gt;gt; gt;gt; prompting
gt; gt; gt;gt; gt;gt; when
gt; gt; gt;gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt; gt; gt;gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt; gt; gt;gt; gt;gt;
gt; gt; gt;gt; gt;gt; Tom
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;
--
Dave Peterson
Dave,
Thanks, it looks like the app gens the popup each time, regardless of the
displayalerts setting. Seems like I'm stuck with this mode of operation. I
did try to first clear the cells that are being written by the histogram app
and that seems to prevent the popup message from happening.
quot;Dave Petersonquot; wrote:
gt; Sometimes, there's code that turn the alerts back on--and you have no control
gt; over that code.
gt;
gt; If you only get the popup once, then I'm guessing that the histogram turns
gt; alerts back on and the second call is causing the trouble.
gt;
gt; If you're getting that popup twice (one time for each call), then there must be
gt; something in the Histogram routine that turns it on -- even if you dislike it.
gt;
gt; I'd try this (Untested):
gt;
gt; application.displayalerts = false
gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
gt; ActiveSheet.Range(quot;$T$23:$T$2055quot;), _
gt; ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
gt;
gt; application.displayalerts = false 'turn it off once more
gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
gt; ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
gt; ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
gt;
gt; application.displayalerts = true 'probably unnecessary if Histogram does it!
gt;
gt;
gt; It may not help, but it can't hurt to try.
gt;
gt;
gt; Austin wrote:
gt; gt;
gt; gt; Here's the Macro code that is causing the popup OK prompt to overwrite
gt; gt; existing cells:
gt; gt; ------------------------------------------------------------------------
gt; gt; Sub Sheets_Update()
gt; gt; 'Histogram_Update Macro
gt; gt; '
gt; gt; Application.DisplayAlerts = False
gt; gt;
gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; gt; ActiveSheet.Range(quot;$T$23:$T$2055quot;) _
gt; gt; , ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; gt; ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
gt; gt; ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
gt; gt;
gt; gt; Application.DisplayAlerts = True
gt; gt; End Sub
gt; gt; -----------------------------------------------------------------------------------------------
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt; gt; Post the code you have
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Peo Sjoblom
gt; gt; gt;
gt; gt; gt; Excel 95 - Excel 2007
gt; gt; gt; Northwest Excel Solutions
gt; gt; gt; www.nwexcelsolutions.com
gt; gt; gt; quot;It is a good thing to follow the first law of holes;
gt; gt; gt; if you are in one stop digging.quot; Lord Healey
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Peo,
gt; gt; gt; gt;
gt; gt; gt; gt; I tried your suggestion but it didn't help, I still get the dialogue box
gt; gt; gt; gt; to
gt; gt; gt; gt; press quot;OKquot;. Any other ideas?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; Oops! Last but second line should be
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Application.DisplayAlerts = True
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Peo
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt; Sub MyMacro()
gt; gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt; gt;gt; gt; 'your code here
gt; gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt; gt;gt; gt; End Sub
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; --
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Regards,
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Peo Sjoblom
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; nwexcelsolutions.com
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; gt; gt;gt; gt; ...
gt; gt; gt; gt;gt; gt;gt; I've written a macro that uses the histogram tool. When using the
gt; gt; gt; gt;gt; gt;gt; macro,
gt; gt; gt; gt;gt; gt;gt; it
gt; gt; gt; gt;gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which
gt; gt; gt; gt;gt; gt;gt; makes
gt; gt; gt; gt;gt; gt;gt; me
gt; gt; gt; gt;gt; gt;gt; hit enter on the keyboard. I just want it to continue without
gt; gt; gt; gt;gt; gt;gt; prompting
gt; gt; gt; gt;gt; gt;gt; when
gt; gt; gt; gt;gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt; gt; gt; gt;gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt; gt; gt; gt;gt; gt;gt;
gt; gt; gt; gt;gt; gt;gt; Tom
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;
If you clear out that range (and a bit more), does that help? (Untested,
though)
Austin wrote:
gt;
gt; Dave,
gt;
gt; Thanks, it looks like the app gens the popup each time, regardless of the
gt; displayalerts setting. Seems like I'm stuck with this mode of operation. I
gt; did try to first clear the cells that are being written by the histogram app
gt; and that seems to prevent the popup message from happening.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Sometimes, there's code that turn the alerts back on--and you have no control
gt; gt; over that code.
gt; gt;
gt; gt; If you only get the popup once, then I'm guessing that the histogram turns
gt; gt; alerts back on and the second call is causing the trouble.
gt; gt;
gt; gt; If you're getting that popup twice (one time for each call), then there must be
gt; gt; something in the Histogram routine that turns it on -- even if you dislike it.
gt; gt;
gt; gt; I'd try this (Untested):
gt; gt;
gt; gt; application.displayalerts = false
gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
gt; gt; ActiveSheet.Range(quot;$T$23:$T$2055quot;), _
gt; gt; ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
gt; gt;
gt; gt; application.displayalerts = false 'turn it off once more
gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;, _
gt; gt; ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
gt; gt; ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
gt; gt;
gt; gt; application.displayalerts = true 'probably unnecessary if Histogram does it!
gt; gt;
gt; gt;
gt; gt; It may not help, but it can't hurt to try.
gt; gt;
gt; gt;
gt; gt; Austin wrote:
gt; gt; gt;
gt; gt; gt; Here's the Macro code that is causing the popup OK prompt to overwrite
gt; gt; gt; existing cells:
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Sub Sheets_Update()
gt; gt; gt; 'Histogram_Update Macro
gt; gt; gt; '
gt; gt; gt; Application.DisplayAlerts = False
gt; gt; gt;
gt; gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; gt; gt; ActiveSheet.Range(quot;$T$23:$T$2055quot;) _
gt; gt; gt; , ActiveSheet.Range(quot;$AB$8quot;), , False, False, False, False
gt; gt; gt; Application.Run quot;ATPVBAEN.XLA!Histogramquot;,
gt; gt; gt; ActiveSheet.Range(quot;$B$8:$B$2055quot;), _
gt; gt; gt; ActiveSheet.Range(quot;$H$8quot;), , False, False, False, False
gt; gt; gt;
gt; gt; gt; Application.DisplayAlerts = True
gt; gt; gt; End Sub
gt; gt; gt; -----------------------------------------------------------------------------------------------
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Post the code you have
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Regards,
gt; gt; gt; gt;
gt; gt; gt; gt; Peo Sjoblom
gt; gt; gt; gt;
gt; gt; gt; gt; Excel 95 - Excel 2007
gt; gt; gt; gt; Northwest Excel Solutions
gt; gt; gt; gt; www.nwexcelsolutions.com
gt; gt; gt; gt; quot;It is a good thing to follow the first law of holes;
gt; gt; gt; gt; if you are in one stop digging.quot; Lord Healey
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Peo,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I tried your suggestion but it didn't help, I still get the dialogue box
gt; gt; gt; gt; gt; to
gt; gt; gt; gt; gt; press quot;OKquot;. Any other ideas?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;gt; Oops! Last but second line should be
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; Application.DisplayAlerts = True
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; Peo
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt; gt; gt; gt;gt; ...
gt; gt; gt; gt; gt;gt; gt; Sub MyMacro()
gt; gt; gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt; gt; gt;gt; gt; 'your code here
gt; gt; gt; gt; gt;gt; gt; Application.DisplayAlerts = False
gt; gt; gt; gt; gt;gt; gt; End Sub
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; --
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; Regards,
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; Peo Sjoblom
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; nwexcelsolutions.com
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; quot;Austinquot; gt; wrote in message
gt; gt; gt; gt; gt;gt; gt; ...
gt; gt; gt; gt; gt;gt; gt;gt; I've written a macro that uses the histogram tool. When using the
gt; gt; gt; gt; gt;gt; gt;gt; macro,
gt; gt; gt; gt; gt;gt; gt;gt; it
gt; gt; gt; gt; gt;gt; gt;gt; generates a dialogue box for quot;OKquot; to overwrite existing data which
gt; gt; gt; gt; gt;gt; gt;gt; makes
gt; gt; gt; gt; gt;gt; gt;gt; me
gt; gt; gt; gt; gt;gt; gt;gt; hit enter on the keyboard. I just want it to continue without
gt; gt; gt; gt; gt;gt; gt;gt; prompting
gt; gt; gt; gt; gt;gt; gt;gt; when
gt; gt; gt; gt; gt;gt; gt;gt; running the macro. I can't seem to find the magic to disable this. Any
gt; gt; gt; gt; gt;gt; gt;gt; thoughts from anyone. Help much appreciated. Thanks.
gt; gt; gt; gt; gt;gt; gt;gt;
gt; gt; gt; gt; gt;gt; gt;gt; Tom
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
留言列表
