Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent unhide sheet | Excel Worksheet Functions | |||
macro to unhide a sheet | Excel Discussion (Misc queries) | |||
Fed value to unhide rows in another sheet | Excel Programming | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Can't see sheet, and have tried unhide, etc? | Excel Worksheet Functions |