XLHidden 2

[smurf01]

Hi, Can anyone help me, A former colleague created an XL workbook that has two hidden sheets if I use Format>Sheets>Unhide there are no sheets showing to unhide. If I look at the properties in VBA the sheets are set to xlHidden, I tried changing the property but it won't let me. I have scoured the code in the workbook and the sheets to see if I can find any reference to the sheets but alas NO Regards

Paul

 

[xlbo]

The sheets are "very hidden". This means that they can only be unhidden via code

For each ws in activeworkbook.worksheets
if ws.visible = xlveryhidden then
ws.visible = true
else
end if
next

users cannot unhide the sheets manually Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes

 

[smurf01]

Geoff, Thanks for the speedy reply
Would I put that code into the Workbook ? Also how would he have hidden it originally ? Regards

Paul

 

[RobBroekhuis]

The only thing I don't understand is why Paul can't change the status on the VBA property form. Or am I misunderstanding?
Rob

 

[Nikita6003]

Nope - you didn't.

But

xlVeryHidden

's not available in Design-Time so you can't change it using the Sheet's property window
And the REALLY stupid thing's you can do it the other way around: you can use the VBA property window to set an xlVeryHidden sheet's Visible property back to xlVisible

d'oh

Cheers
Nikki

 

[smurf01]

Nikki, tried that it does not work, also the sheet is xlHidden not xlveryhidden

Regards

Paul

 

[Nikita6003]

smurf01
Could be the workbook is protected. Check under TOOLS > PROTECTION: it's protected if it says UNPROTECT WORKBOOK. All options in VBA properties will be unavailable.

Dunno if it's been password-protected; if not, all you need to do is to click UNPROTECT WORKBOOK. If it is - you might have a problem ;-)

HTH

Cheers
Nikki

 

[SkipVought]

Nikki,
Are you running earlier than 97? My 97 & 2002 versions allows xlSheetVeryHidden at design time. It just LOOKS like that value is not available, but it is. Skip,
SkipAndMary1017@mindspring.com

 

[Nikita6003]

Skip,

you're right - even i managed to set it at design time now ;-)

thanks
Nikki

 

[smurf01]

Nikki,
Thanks very much, the workbook was protected. Fortunately one of the passwords i tried worked, I appreciate your help

Have a Star
Regards

Paul

 

[Nikita6003]

& a star for Skip for putting me right ;-)

Cheers folks!