View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Office Friday fun - cracking an excel Quiz...

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" wrote
in message ...

Hiya all!

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

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

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

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

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

Many thanks guys!!


--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile:

http://www.excelforum.com/member.php...o&userid=10602
View this thread: http://www.excelforum.com/showthread...hreadid=501026