Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent unhide sheet acss Excel Worksheet Functions 2 October 29th 08 04:56 AM
macro to unhide a sheet Bill_S Excel Discussion (Misc queries) 1 April 10th 08 05:27 PM
Fed value to unhide rows in another sheet Ram[_5_] Excel Programming 4 July 6th 07 03:08 PM
HELP!! Unhide Sheet with Macro and focus on other sheet [email protected] Excel Discussion (Misc queries) 2 May 23rd 06 07:17 PM
Can't see sheet, and have tried unhide, etc? Anna Excel Worksheet Functions 2 April 4th 06 05:27 PM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"