View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Checkboxes do not show when Worksheets Emailed

Hi Steve

I have test it in 2007
Do you use another version

Let me know and I will test it also in that version

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
Ron
I'm still not seeing the checkboxes. I have tried both with and without
pictures. I am not using a form just directly inputting to a worksheet which
has Checkboxes located on it.
Thanks again for your help
Steve

"Ron de Bruin" wrote:

Hi Steve

I see both (forms and activex checkboxes if I mail)
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

Note: in 2007

If you use Conditional Formatting Icons or Data bars in your Excel 2007 workbook the
receiver will not see them in the mail.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
Worksheets("Start").Range("A1:K55").Select
ActiveWorkbook.EnvelopeVisible = True
sSubject = "Any Text " & CStr(ActiveSheet.Range("B2").Value)
' vSend = "zxc@123corp"
With ActiveSheet.MailEnvelope
.Introduction = ExtraStuff
.Item.To = vSend
.Item.Subject = sSubject
.Item.Send
End With

This above code runs and the resulting email shows blank where the
checkboxes should be