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