Expert placed a Macro that he claims cannot be beat

[TPD]

OK,..this Excel genius always likes to tease me because I'm a struggling newbie. He likes to tease me with his skills. He has sent me a worksheet that he claims cannot be bypassed without selecting an OK button to get to the sheet I need. I beat it it the first time by simply unhiding the sheet but now I believe he has placed a macro in there!

Basically it's a review sheet that you must click OK on in order to reveal the workbook I want. I know it's a macro,...but is there anyway to beat it WITHOUT clicking on the review sheet?? I think he beat me on this!!

The macro on the click buttons is this:
Sheet5.ShowForms
All Open workbooks


todd

 

[Juan Pablo González]

Why don't you disable the macros ?

 

[TPD]

I did,..but then I still cannot find the two worksheets...Somehow they are hidden. If I go to unhide sheets,..they are not there. Where did he hide them?

 

[Norie]

Todd

Try going to the VBE using Alt+F11, you should see all the sheets there.

Check their visible property.

If there is code running then hit CTRL+BREAK.

 

[TPD]

When I hit Alt F11 I see this:

Sub ShowForms1()
'
'
'

If Range("D7").Value = True And Range("D12") = True And Range("D17") = True Then
Sheets("Screening Form").Visible = True
Sheets("Additional Comments").Visible = True
Else
Sheets("Screening Form").Visible = False
Sheets("Additional Comments").Visible = False
End If
End Sub


The sheets I want to see are indeed the Screening Form and Additional Comments,..but even if I hit the CTRL + BREAK (I hit the pause/break button on my keyboard) nothing happens.

 

[Norie]

Is that all the code?

 

[TPD]

That's it. You think he has done something else? I mean the actual workbook contained 4 sheets. If I do nothing and look at the format>sheets>unhide,...two of the four are there. He somehow as buried the first two sheets beneath his wonderful review sheet.

Maybe he grouped the tabs? I don't know.

If I rightclick on the tab of the review sheet, it too has the macro....

I tried breaking all of the lines of code,. and it says break at the top of the VBE menu, but I still cannot get access to them. He has to have them grouped or something in addition to the macro.

He also has hidden column D for some reason and Column Unhide is not an option that's available. He's good.

td

 

[TPD]

I finally got it. I had to also ctrl + break on the code from the worksheet tab. I right clicked on the tab and then hit view code and then hit ctrl+break on the code in there too.

It did it.

Thanks man! I can be proud again,...even though you actually solved it! Not me! I won't tell him that though (until later on perhaps)

td

 

[Norie]

Could I actually ask what you are trying to do?

Did you check the sheets Visible property in VBE?

As for the hidden column, just select all cells and goto Format>Column>Unhide.

 

[DominicB]

Good evening TPD

All macros can be beat and all passwords can be removed. Fact.

There's even a guy on the internet who challenges people to send him a worksheet that he cannot open up and expose. He's not been beaten yet.

http://www.xl-logic.com/pages/challenge.html

Any takers?

DominicB