Hi Maileen,

Try:

Application.Dialogs(xlDialogSaveAs).Show


---
Regards,
Norman



"Maileen" wrote in message
...
Hi,

I would like to know how to do a save dialog box (using macro) where the
user select folder and filename of what macro created.
Can anyone help me please ?

thanks a lot,
Maileen