creating a macro for a "Save As" box
 

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

"MysticMarley" wrote:

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.

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

"FSt1" wrote:

hi,
add this to the macro wizard code

Application.Dialogs(xlDialogSaveAs).Show

regards
FSt1

"MysticMarley" wrote:

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.