This will propt user to save as
Application.Dialogs(xlDialogSaveAs).Show

"gfkbob" wrote:

I am trying to add a 'SaveAs' to a macro so the user must save the
workbook under a different name. I have tried
"Application.getsaveasfilename", "workbook.saveas",
"activeworkbook.saveas". These are not working. Any ideas?