pause for input during macro

[rmills]

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?

 

[Tom Ogilvy]

Put up an inputbox

ans = InputBox("enter new name")

--
Regards,
Tom Ogilvy

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?