Office Friday fun - cracking an excel Quiz...
 

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

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

Office Friday fun - cracking an excel Quiz...
 

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!


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

Office Friday fun - cracking an excel Quiz...
 

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 wrote:

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

--

Dave Peterson

Office Friday fun - cracking an excel Quiz...
 

Genius! :eek:

Works a treat!!! :rolleyes:


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