Found 7th Nov 2009
Hi, i am creating a quiz in excel for children in need at work. i have seen other quiz's on the internet made in excel with pictures etc. I am looking to stop people from cheating on it, and finding my answers(i will be locking the sheet, and cells).

once the quiz is finished i will hapilly upload it to this website for your own pleasure, but i know of a way to get everysingle answer on my spreadsheet( even though it is password protected and cells are locked) but with a quiz i downloaded off the internet the same technique does, not apply.

i know this is a little vague, but i do not want to give the tecnique out to you if i am to give it people on here at a later date.

If you are very good at excel, i will glady tell you how i managed to get the answers from one but not the other.

Help please, it is going on sale at work on tuesday and im currently stuck.


Thank you

  1. Misc
Groups
  1. Misc
4 Comments

You can unlock them with a very simple free program off the net. Why not get is to look up the answer from the web so the answers are not stored locally ?

Use VBA instead of pure Excel functions.

Original Poster

ChrisUK;6811849

You can unlock them with a very simple free program off the net. Why not … You can unlock them with a very simple free program off the net. Why not get is to look up the answer from the web so the answers are not stored locally ?



Because it a work quiz, and not all pc's are on the internet, but thank you for the help.

Original Poster

pghstochaj;6811887

Use VBA instead of pure Excel functions.



ive only just cracked the formulas in excel to work, i havent got time to learn the VBA side of it too. Thanks anyway. rep
Post a comment
Avatar
@
    Text
    Top Discussions
    1. Unisex/Women’s Nintendo Christmas Jumper?11
    2. I posted a deal that has been removed39
    3. Looking to travel from belfast11
    4. Gatwick Airport Parking77

    See more discussions