PopUp Question

[MR3]

When I run my Macro it pops up a window



Is there a way I can have my code to automatically Press "Ok", rather than me having to manually press or click ok to continue running the macro?

 

[Rick Rothstein]

Put this line at the start of your code...

Application.DisplayAlerts = False

and make sure this line of code gets executed before your code ends...

Application.DisplayAlerts = True

 

[MR3]

worked like a charm!