Another Quiz that needs unhiding...

[clivekendall]

Folks, anyone able to help me err... kinda cheat on a quiz we're doing in the office...?

I know there is a second sheet to this excel quiz, it's hidden and after pressing ALT-F11 I can see it and it's properties tell me it's Visible status is 0 - xlSheetHidden. This is locked and I cannot change it - anyone able to advise how I get to the second sheet...?

Thanks in advance
Clive

 

[Oaktree]

You could make a new sheet, and put ='Hidden Sheet'!A1 in A1 of the new sheet.

Then, copy A1 down and right through the expected range of data you'd like to see from 'Hidden Sheet'.

 

[clivekendall]

Thanks for the reply OakTree but I'm not able to add a new sheet to the workbook.. It's pretty much locked up..

 

[Oaktree]

Ok, but you could reference it from a new workbook though. Same logic still applies.