Is there a way of pausing a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi i am trying to record a macro to create a new worksheet and then save it
as the title of that worksheet but i cant get the macro to pause or wait for
me to enter in the file name and it just keeps trying to give the sheet the
same name that i saved it to when i was recording it. Is there a way of
getting it to pause so thta i can enter in the file name before it continues
with the rest of its instructions
 
Add test code to your macro

1) Use an Inputbox so you can type in information
2) add a statement line Myfilename = "c:\temp\testfile.txt"
3) Write test code that writes too cells on the spreadsheet
Range("A3") = "Test Data"
 
Back
Top