save worksheet then email the saved worksheet
Hi, what I'm looking for is a macro that will save a worksheet as a new
workbook with whatever customer name in a cell in this said worksheet and
then email the new workbook, all by on click. I'm trying to keep this sheet
as dummy proof as possible.
Thanks
|