sheet "hidden" vs "very "hidden"
 

i understand a sheet which is hidden can be made visible by format
sheet unhide.

how can make visible a sheet which is "very hidden". i suppose i'll
have to use a macro code.

can you help please?


--
arunjoshi
------------------------------------------------------------------------
arunjoshi's Profile: http://www.excelforum.com/member.php...fo&userid=8846
View this thread: http://www.excelforum.com/showthread...hreadid=345761

sheet "hidden" vs "very "hidden"
 

You can make this sheet visible by setting the Worksheet.Visible =
True.

You can't unhide sheets hidden using xlVeryHidden without VBA.

sheet "hidden" vs "very "hidden"
 

skrev i melding
oups.com...
You can make this sheet visible by setting the Worksheet.Visible =
True.

You can't unhide sheets hidden using xlVeryHidden without VBA.


Not quite true. Open the VB editor (Alt F11 or similar). Slect the sheet in
the project explorer, it has a property Visible. Change that from 2
VeryHidden to -1 SheetVisible.

HTH. Best wishes Harald