Answer YES to Dialog boxes in Excel macro

[serhat]

I have set up a macro that does a lot of sorting, subtotaling, text t
columns etc. Each time I run the Macro the same dialog boxes pop u
when I created the Macro using the recorder. The dialog boxes are

1- Do you want to replace columns of the distribution cell. (when I d
text to columns)

2- The dialog box that pops up when one does a subtotal.

Is there a way I can somehow disable dialog boxes in the VB code. Or i
the start of the code write something that says Answer Yes to al
dialog boxes that pop up? Or any other way so that I can run the macr
and not have to sit there to answer yes to each box that pops up.

Thanks for your help everyone!

S

 

[Andy Brown]

Is there a way I can somehow disable dialog boxes in the VB code.

Application.DisplayAlerts = False

your code

Application.DisplayAlerts = True

Rgds,
Andy

 

[serhat]

Thanks Andy!!! Worked like a charm