It worked great, what I found out was I cant just send the form i would
have to send the whole wb as an email attachment now I am trying to
write vb to lock part of the form and attach itself to an outgoing
email


--
gachett
------------------------------------------------------------------------
gachett's Profile: http://www.excelforum.com/member.php...o&userid=29944
View this thread: http://www.excelforum.com/showthread...hreadid=496428