look at GetSaveAsFilename method in help

--
HTH

Bob Phillips

"Mike_M" wrote in message
ups.com...
I need a quick macro to attach to a button on each worksheet within a
workbook with multiple worksheets, which will export that workbook into
a new file which the user will then be prompted to save as a new file
and to choose the location it is saved in. I know this is easy, I'm
just being lazy today!

Thanks in advance

Mike