I have coded my spreadsheet to send a copy of my active spreadsheet to the email addresses which i have put into the code.

When the attachment comes through to the email addresses, The customer will open the attachment and will have to enable macros for the spreadsheet to work, What i want is for the customer to recieve the spreadsheet but not have to enable the macros, there must be something out there which will auto do this for them.