Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

smurf01 (IS/IT--Management)
20 Jan 03 7:41
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 (MIS)
20 Jan 03 7:53
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 (IS/IT--Management)
20 Jan 03 7:55
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 (TechnicalUser)
20 Jan 03 7:57
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

Helpful Member!  Nikita6003 (Programmer)
20 Jan 03 8:05
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 (IS/IT--Management)
20 Jan 03 8:19
Nikki, tried that it does not work, also the sheet is xlHidden not xlveryhidden

Regards

Paul

Nikita6003 (Programmer)
20 Jan 03 8:27
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
Helpful Member!  SkipVought (Programmer)
20 Jan 03 8:30
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 (Programmer)
20 Jan 03 8:35
Skip,

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

thanks
Nikki
smurf01 (IS/IT--Management)
20 Jan 03 8:41
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 (Programmer)
20 Jan 03 8:49
& a star for Skip for putting me right

Cheers folks!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close