Pause in an Excel Macro

  • Thread starter Thread starter Harry Bennett
  • Start date Start date
H

Harry Bennett

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
 
Back
Top