Emailing a sheet from a workbook with VBA
 

I have a workbook that a user can select various products out of and then submit an order via a macro to a named individual based on the value of specific drop downs.

I've used Ron De Bruin's sendmail function which works in that it copies the sheet to another workbook and attaches the sheet to the mail. The mail is populated via the htmlbody and cell references for the specific details.

However, I cannot get the sheet to stay protected to prevent users changing the costs. I also want to have an additional function so the recipient can edit some details and then automatically forward the sheet to a third recipient.

Ive attached a copy of the edited code and a screen shot of the sheet im sending.

Anyone help??

Thanks