View Single Post
  #2   Report Post  
FSt1
 
Posts: n/a
Default

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.