Pause in an Excel Macro

I need to create a macro with multiple functions, one of
which is "SaveAs", so I can save the worksheet to a
different name. How can I record/enter a "pause" function
into a macro to allow for variable input by the user, and
then restart the run/play of the macro when completed.

Harry,

Simply use

ActiveWorkbook.SaveAs Application.GetSaveAsFilename

That takes care of all your concerns.

HTH,
Bernie


"Harry Bennett" wrote in message
...
I need to create a macro with multiple functions, one of
which is "SaveAs", so I can save the worksheet to a
different name. How can I record/enter a "pause" function
into a macro to allow for variable input by the user, and
then restart the run/play of the macro when completed.