How do you unlock one of these excel "quizzes" ?

Question

I get sent loads of them by various friends and always wondered if there was a way to access the hidden/locked content... Is there?

Im just curious as to how you make one!

Answer 1

If you just want to cheat and see the answers you can save the file as a text file (with .csv extension) then open the .csv file in Excel.
As to how to make one that is just a matter of writing the correct formula and hiding the right cells. You need to play with that yourself.

Answer 2

Excel Quizzes

Answer 3

DISCLAIMER! READ THIS FIRST MATE!!:

I provide this knowledge in the understanding that it will not be used in a malicious way. I provide this knowledge as is and take no responsibility for any damage caused to you or anyone else's computer as a direct or indirect consequence of this disclosure.

I hereby resolve myself of any liability for the actions or utilisation caused or created from the adaptation of this code.

By reading on you accept that this code is purely for the purpose of educating you on the trial and improvement process and the utilisation of the iteration process to exploit security flaws.

Thank you for reading

To unlock the workbook and make the answer sheets visible run this macro and then select Format > Sheet > Unhide

Macro to unlock workbook:

Sub RemoverWorkBookProtection()

On Error Resume Next
Dim attempt As String
Dim b As Byte
Dim length As Byte
length = 1

Start:
ActiveWorkbook.Unprotect attempt
If Err = 1004 Then 'failed
'try next
b = b + 1
'increment count
attempt = Left(attempt, length - 1) & Chr(b)
'preserve string
If b = 255 Then
''
b = 0
'stop overflow
length = length + 1
'increase length
End If
''
GoTo Start
''loop back
Else:
MsgBox "Done!"
ActiveWorkbook.Unprotect attempt
End If
End Sub

Answer 4

Some of the quizzes are written using vb script & are usually password protected. However, some answers are in hidden columns & the row & column headers are hidden. One way to find the answer is to press the "end" key & select any of the 4 cursor keys. If there's data in a particular cell in the row or column when you do the above, chances are you'll stumble across the hidden answers.

Answer 5

You may not be able to change the settings if it is password protected, but if it is not, you can unhide the sheets in the Visual Basic Editor.

To get to it, either press Alt+F11, or goto Tools - Macro - Visual Basic Editor. From there select the sheet you want to unhide on the top left-hand column, and in the bottom left column - change the "Visibale" setting to "-1 - xlSheetVisible" (it's a multiple choice setting, you don't have to type it or anything).

Answer 6

Hi,

Select all the cells by pressing Ctrl-A, Copy and paste the contents to a new WorkBook.

Hidden Cells and contents Revealed.

Hope this works,

Thanks,
Selva

Answer 7

The person who created the Excel workbook or worksheet sets the permissions and passwords - you cannot access the locked content without the passwords.

Answer 8

you can yep you can goto tools protection unprotect worksheet if there not locked this will wor or you could also try the following tools options then selecting view tab and formulars which will show you the formulars used

Answer 9

Hahaha thats funny :) LOL should a 2nd grader know about that?!

Answer 10

You need the password, without that you're stuck.