View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KateB KateB is offline
external usenet poster
 
Posts: 21
Default After e-mail, unhide sheet


I am using Ron de Bruin's VBA script to mail the content of certain cells to
my e-mail address. http://www.rondebruin.nl/mail/folder3/mail4.htm
This works fine (thank you very much!) However, I get a pop-up box asking
if I really want the program to send an e-mail on my behalf. When the user
has clicked yes and the e-mail is gone, I then want a sheet to unhide and the
focus move to it so they can print it if they so wish.

Basically, it is a 'quiz' where once the user has completed it and attained
a certain score I need their details for monitoring purposes, but I then want
them to have a certificate as proof of completion. I don't want them to be
able to bypass me getting their details!

I hope this makes sense and someone can help. I am not a programmer so
simple 'idiot proof' terms would be greatly appreciated!

Many thanks
Kate