Help needed with office quiz

gedclink · May 7th, 2002, 07:28 AM

Get a lot of " quizzes " into the office through e-mail from colleagues etc..We can't always complete them ( due to lack of knowledge ) and want to know how we can find out the answers that appear to be "hidden" in the worksheet.

Essentially it would appear that when you type in a correct answer, it checks it then allocates a point . Someone told me you could " reveal " the answers by copying the original sheet and pasting it into a new sheet. This doesn't work..Any help please...

If anyone wants the quiz to try out on just ask and I'll mail it.

Thanks

Ged

crimlet · May 7th, 2002, 07:31 AM

yes please e-mail to jason.marter@bt.com

MattB · May 7th, 2002, 08:18 AM

Go on then!
mattburge@hotmail.com

sann0638 · May 8th, 2002, 03:02 AM

unhiding rows and columns sometimes works. pls send to sann0638@hotmail.com

[ This Message was edited by: sann0638 on 2002-05-08 02:03 ]

EBK · May 8th, 2002, 03:07 AM

also to excelbookkeeping@yahoo.com.au

Thanks

Paul

Nobby · May 8th, 2002, 03:07 AM

In the box where it tells you if you are correct or not, you will often find the formula, something like =IF(A1="SomeTextHere", "Correct", "Incorrect").

Now you know that the answer is hidden in a Named Range. Now go to Edit/Go To and type in "SomeTextHere" - that will take you to the answers.

Nobby

Iain Lewis · May 8th, 2002, 03:16 AM

Could i have a copy please

ijlewis@mtc.ricardo.com

thanks.

Iain Lewis · May 8th, 2002, 03:19 AM

To ( kind of ) answer your question - sheets have 2 levels of being hidden. There is the usual Hidden value ( which you can set through Format...Sheet...Hide ) and then there is Very Hidden which can be set through the VBE.

If you've got sheets which are password protected & would like some code to remove the password ( it will only strip it, not tell yuo what it is ) then let me know & I'll post it.

philR · May 8th, 2002, 03:26 AM

Iain, I would be very interested in the things you mentioned in your reply. How to make a sheet 'Very Hidden' (love that phrase!) and how to strip the code from a password protected sheet. Thanks

PhilR

neills · May 8th, 2002, 03:34 AM

lian

I am interested in both of these please tell me more

thanks neill

[ This Message was edited by: neills on 2002-05-08 02:35 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 07:28 AM	#1
gedclink New Member Join Date: May 2002 Posts: 1	Get a lot of " quizzes " into the office through e-mail from colleagues etc..We can't always complete them ( due to lack of knowledge ) and want to know how we can find out the answers that appear to be "hidden" in the worksheet. Essentially it would appear that when you type in a correct answer, it checks it then allocates a point . Someone told me you could " reveal " the answers by copying the original sheet and pasting it into a new sheet. This doesn't work..Any help please... If anyone wants the quiz to try out on just ask and I'll mail it. Thanks Ged

May 7th, 2002, 07:31 AM	#2
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	yes please e-mail to jason.marter@bt.com

May 7th, 2002, 08:18 AM	#3
MattB Board Regular Join Date: Mar 2002 Posts: 62	Go on then! mattburge@hotmail.com

May 8th, 2002, 03:02 AM	#4
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	unhiding rows and columns sometimes works. pls send to sann0638@hotmail.com [ This Message was edited by: sann0638 on 2002-05-08 02:03 ]

May 8th, 2002, 03:07 AM	#5
EBK New Member Join Date: Apr 2002 Location: Paul, Sydney Australia Posts: 10	also to excelbookkeeping@yahoo.com.au Thanks Paul

May 8th, 2002, 03:07 AM	#6
Nobby Board Regular Join Date: Feb 2002 Location: United Kingdom Posts: 68	In the box where it tells you if you are correct or not, you will often find the formula, something like =IF(A1="SomeTextHere", "Correct", "Incorrect"). Now you know that the answer is hidden in a Named Range. Now go to Edit/Go To and type in "SomeTextHere" - that will take you to the answers. Nobby

May 8th, 2002, 03:16 AM	#7
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Could i have a copy please ijlewis@mtc.ricardo.com thanks.

May 8th, 2002, 03:19 AM	#8
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	To ( kind of ) answer your question - sheets have 2 levels of being hidden. There is the usual Hidden value ( which you can set through Format...Sheet...Hide ) and then there is Very Hidden which can be set through the VBE. If you've got sheets which are password protected & would like some code to remove the password ( it will only strip it, not tell yuo what it is ) then let me know & I'll post it.

May 8th, 2002, 03:26 AM	#9
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	Iain, I would be very interested in the things you mentioned in your reply. How to make a sheet 'Very Hidden' (love that phrase!) and how to strip the code from a password protected sheet. Thanks PhilR

May 8th, 2002, 03:34 AM	#10
neills Board Regular Join Date: May 2002 Location: wirral uk Posts: 104	lian I am interested in both of these please tell me more thanks neill [ This Message was edited by: neills on 2002-05-08 02:35 ]