Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Help needed with office quiz

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go on then!
    mattburge@hotmail.com

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

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

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Paul, Sydney Australia
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    also to excelbookkeeping@yahoo.com.au

    Thanks

    Paul

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could i have a copy please

    ijlewis@mtc.ricardo.com

    thanks.

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Sheffield, UK
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  10. #10
    Board Regular
    Join Date
    May 2002
    Location
    wirral uk
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •