I built a macro that alters multiple files, but the input data is
occasionally unreliable in that:
1. there may be more columns source data than I expect

While this is really too problems one of my answers to finding the issues is
to pause the macro in a way that
the user can double check the data manually and perhaps alter certain things
before continuing.

For the First part My plan would be to put this pause just before the data
in question is saved. As long as the dialog is nonmodal I should be able to
do what I want
Can anybody show me some code for this?




Thanks Henry :-)