creating a macro for a "Save As" box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a macro that will display the "Save As" dialog box? When I
create it using the the Macro Wizard, it doesn't bring up the "Save As"
window. It just saves at the previous location and name. My attempts to
alter the VBA code have failed.
 
hi,
add this to the macro wizard code

Application.Dialogs(xlDialogSaveAs).Show

regards
FSt1
 
Thank you FSt1! It worked perfectly and completed the final suggestion from
my manager for a spreadsheet project.
 
Back
Top