Emailing a sheet from a workbook with VBA

H

Highlander2536

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

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

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

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

Anyone help??

Thank

+-------------------------------------------------------------------
|Filename: sendmail.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=854
|Filename: quote template.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=855
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top