Thread: pause for input during macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?


Reply With QuoteReply With Quote