Thread: Need simple prompt to save at end of macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default Need simple prompt to save at end of macro
Put the following line of code at the end of your macro:

Application.Dialogs(xlDialogSaveAs).Show

--
Kevin Backmann


"KelliInCali" wrote:

I just want to bring up the "save as" prompt at the end of my macro so that
the user knows when the function is complete and ready to save. I don't want
to assign a path or filename, they will do that manually.

tia,
Kelli
Reply With QuoteReply With Quote