Application.GetSaveAsFilename

you can look up GetSaveAsFilename method in help

--
Regards,

Peo Sjoblom

(No private emails please)


"bbc1" wrote in message
...
I would like to put a button on a spreadsheet and run a macro that will
bring
up the save as dialog box.