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.
|