Hi Henry,
It seems putting in a Input Box, asking if the user is ready to save or
would like to change data, woud do this for you. Then the useer can respond
to either save or add data. Something like this:
Sub Macro1()
Dim Message, Title, Default, MyValue
Message = "Save or Enter more data?"
Title = "Save or enter more data?"
Default = "Save" ' Set default.
MyValue = InputBox(Message, Title, Default)
If MyValue < "Save" Then GoTo Bottom
Stop
'Save file routine
Bottom:
End Sub

"Henry Stock" wrote:

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 :-)