ExcelBanter - pause for input during macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - pause for input during macro (https://www.excelbanter.com/excel-programming/289527-pause-input-during-macro.html)

Rmills

pause for input during macro

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

pause for input during macro

Put up an inputbox

ans = InputBox("enter new name")

--
Regards,
Tom Ogilvy

rmills wrote in message
...
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?

All times are GMT +1. The time now is 10:26 AM.