![]() |
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 |
All times are GMT +1. The time now is 05:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com