After e-mail, unhide sheet

K

KateB

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
 

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