Save-As Option

[GDunn]

Hi, a file I have created which consists of a data entry sheet and a results sheet. The results sheet appears once a macro button is activated.
a) I would like Save-As button for the results sheet, so that external clients can keep the output on their hard-drive. b) I guess this will also consist of requesting a Save-As location?
Any help much appreciated.

 

[Von Pookie]

Check out Application.GetSaveAsFilename. It should do what you want.