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
+-------------------------------------------------------------------
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
+-------------------------------------------------------------------