Hello,
I am trying to add a functionality to one of my existing CommandButton macro that will copy certain sheets from the workbook (Sheet3 and Sheet4, but i'd prefer use their names) to a new workbook and attach that new workbook to an email with predefined recipient and subject. If possible also to delete this new workbook after. The idea is to send just part of the file to the person for update.
Thanks in advance.
I am trying to add a functionality to one of my existing CommandButton macro that will copy certain sheets from the workbook (Sheet3 and Sheet4, but i'd prefer use their names) to a new workbook and attach that new workbook to an email with predefined recipient and subject. If possible also to delete this new workbook after. The idea is to send just part of the file to the person for update.
Thanks in advance.
