Thankyou found a script on this which I could apply to a command button on
the worksheet
Application.ExecuteExcel4Macro("SAVE.AS?()")

"Peo Sjoblom" wrote:

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.