Unhiding xlveryhidden

[MarkAndrews]

I have a document (a quiz), which has some sheets which are Xlveryhidden

Is there anyway I can run a code in my workbook, which will bypass any passwords and unhide these documents?

Thanks

 

[Von Pookie]

Yes (Edit: At least I *think* there is. Can't think of it off the top of my head, though). However, this board is not the place to ask about password breaking:
http://www.mrexcel.com/board2/viewtopic.php?t=198756

 

[MarkAndrews]

Sorry, there are no passwords in the document

I am a novice with Xlveryhidden

TIA

 

[DominicB]

Hi Mark

Go into the VBE, from the Project window select the xlVeryHidden sheet, then go to the Properties window and change the Visible flag to xlSheetVisible.

HTH

DominicB

 

[njimack]

Sheets("Sheet1").Visible = True