Office Friday fun - cracking an excel Quiz...

[Petitboeuf]

Hiya all!

I know I shouldn't do that but after downloading a quiz of the web fo
our office Friday quiz I wanted to be able to get the answers so that
can mark my colleagues...

Unfortunately, even after removing both worksheet and workboo
passwords (which are now unprotected) I cannot unhide the worksheet
which hold the references.

I can clearly see them in VBA (2 of them + the front page quiz one) bu
cannot access them in Excel...

The VBA code I used to unprotect my workbook is available for free o
the web and widely distributed.

Any suggestions before I have to change my quiz for this afternoon?

Many thanks guys!

 

[Bob Phillips]

Are they very hidden. In the VBIDE, select the worksheet and check the
properties, F4. Check the Visible property.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Petitboeuf]

ah... well then when trying to get VBAProject Properties... Password
protection kicks in!

I thought I managed to get rid of the passwords...

Harder than I thought then!

 

[Dave Peterson]

If you know the name of the sheets to unhide, maybe you can just steal the
values from those pages:

Insert a new sheet
=if('hidden'!a1="","",'Hidden'!a1)

Drag down and to the right

 

[Petitboeuf]

Genius!

Works a treat!!!