Macro to export a worksheet and save as new file

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

look at GetSaveAsFilename method in help

--
HTH

Bob Phillips

"Mike_M" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Thanks - much appreciated

Mike