Movie Quiz in Excel
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Movie Quiz in Excel

  1. #1
    Guest

    Default

     
    Hiya!
    I'm compiling a movie quiz where people have to identify a film and type it in. They get awarded one point for each correct answer. At the moment I'm using the IF function to award the point (e.g. =IF(A1="The Terminator",1,IF(A1="Terminator 2",1,0)). Obviously I don't want people to see these formulas but when I hide the formulas and then protect the sheet they can't type in their answers. How can I get around this? All help very gratefully received!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Before protecting the sheet, unlock the cells that they will enter the answers in (In this case, A1). Then protect the sheet. They'll be able to enter data and won't see the formulas either.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To unlock the cells as Juan has said, select the cells, hit Format-Cells-Protection and uncheck the Locked checkbox.
    ~Anne Troy

  4. #4
    Guest

    Default

      
    Legend.

    Thank you ever so much.

    Anna.

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
  •  

 

 
DMCA.com