Bypassing OK/Cancel Dialog Box

  • Thread starter Thread starter danchen
  • Start date Start date
D

danchen

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL03: Avoid "workbook contains links" msg when opening 5
screenupdating=false not working 1
VBA Save As problem with file that already exist 2
SaveAS dialog box gives run time error 1004 in Excel VBA 3
ok cancel dialog box 4
Add-in Error "Application-defined or Object-Defined Error" 1
VBA Password box appearing at close 4
Addin Install 4

Back
Top