PC Review


Reply
Thread Tools Rate Thread

After e-mail, unhide sheet

 
 
KateB
Guest
Posts: n/a
 
      9th Jul 2009

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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
I have a sheet that I cannot unhide. Ted Microsoft Excel Programming 5 11th Oct 2009 12:33 AM
Prevent unhide sheet acss Microsoft Excel Worksheet Functions 2 29th Oct 2008 04:56 AM
Re: Why Are Hide Sheet and Unhide Sheet Hidden? (Excel 2007, Windows XP) pub Microsoft Excel Discussion 0 1st Aug 2008 06:46 AM
HELP!! Unhide Sheet with Macro and focus on other sheet saraqpost@yahoo.com Microsoft Excel Misc 2 23rd May 2006 07:17 PM
Can't see sheet, and have tried unhide, etc? =?Utf-8?B?QW5uYQ==?= Microsoft Excel Worksheet Functions 2 4th Apr 2006 05:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:38 AM.