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