Pause in an Excel Macro

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.
 
B

Bernie Deitrick

Harry,

Simply use

ActiveWorkbook.SaveAs Application.GetSaveAsFilename

That takes care of all your concerns.

HTH,
Bernie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
VBA macro pausing 2
Macro Pause to Select range then Subtotal 0
Drop down list control value in vba 2
Crating User Form to Add Names 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Word macro that can call cells out of Excel for a find and replace 0
VBA word change keys 0

Top