View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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