| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Office Friday fun - cracking an excel Quiz...
Genius!  Works a treat!!!  -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=501026 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Send to from excel 2003 after upgrade from Office 2000 | Excel Discussion (Misc queries) | |||
| Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
| Need to convert Office 97 Excel doc to Office 2003! | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
