Bypassing OK/Cancel Dialog Box
 

Hi all -

I'm running a series of automated regressions out of VBA but there is
some junk text scattered in my workbook. What can I do in VBA to get
the macro to default to "Ok" and bypass the challenges that pop up
(basically, an overwrite text OK/Cancel challenge).

I've already tried Application.DisplayAlerts = False and that didn't
work.



thanks a ton


--
danchen
------------------------------------------------------------------------
danchen's Profile: http://www.excelforum.com/member.php...o&userid=16325
View this thread: http://www.excelforum.com/showthread...hreadid=277136

Bypassing OK/Cancel Dialog Box
 

Hi
what messages are these?

--
Regards
Frank Kabel
Frankfurt, Germany

"danchen" schrieb im Newsbeitrag
...

Hi all -

I'm running a series of automated regressions out of VBA but there is
some junk text scattered in my workbook. What can I do in VBA to get
the macro to default to "Ok" and bypass the challenges that pop up
(basically, an overwrite text OK/Cancel challenge).

I've already tried Application.DisplayAlerts = False and that didn't
work.



thanks a ton


--
danchen
---------------------------------------------------------------------
---
danchen's Profile:
http://www.excelforum.com/member.php...o&userid=16325
View this thread:
http://www.excelforum.com/showthread...hreadid=277136