pause for input during macro

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

Guest

I want a macro to save a spread sheet, reset it for the next week, then save as, pause for the operator to enter new name?
 
Put up an inputbox

ans = InputBox("enter new name")

--
Regards,
Tom Ogilvy

rmills said:
I want a macro to save a spread sheet, reset it for the next week, then
save as, pause for the operator to enter new name?
 
Back
Top