Results 1 to 5 of 5
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sheets VeryHidden (Excel 97/2000)

    I have a workbook which has a "user" and an "admin" mode. The user mode only shows a sub-set of the worksheets in the workbook and hides some of the ActiveX controls on some sheets. The Admin has access to everything (after entering a password).

    I use the sheet attribute visible=xlVeryHidden for those sheets that I do not want anyone to see (Admin included) and it seems to be there's no reason to protect the workbook at all since there is no way anyone can get to these super hidden sheets. (Sheets can be set to Visible, Hidden, VeryHidden).

    My question? Is this reasonable, is there a hole I have't thought of? I mean why bother protecting worksheets which can not be viewed by the user? I have code that protects parts of some sheets but the sheet itself isn't doesn't need to be protected for that to work (also protecting sheets prevents some other features from being accessible to the user).

    Deb <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15> <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sheets VeryHidden (Excel 97/2000)

    So what happens if I - as one of your users - have the new, unprotected, workbook open in user mode and press [alt] + [f11]? What's to stop me resetting .visible this way?

    Brooke

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sheets VeryHidden (Excel 97/2000)

    Yes, you're right. I should of stated that I do have my code (the project) password protected so they can not get in it and change the protection (by writing code). I guess they could write their own project and reference my workbook name and cycle through the worksheets looking for those with the Visible attribute hidden. I'll have to try that myself.

    It's just that some critical features aren't available to protected workbooks and even though I've written the code to get around it (unprotect, do stuff, re-protect) I'd prefer not to. Also, the majority of my users are not VBA saavy but that doesn't mean they can't pass it to someone else is knows what they're doing. We all know Excel is not a secure program no matter what tricks you do in VBA.

    Thnx, Deb

  4. #4
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sheets VeryHidden (Excel 97/2000)

    I'd not even thought of that loophole when I replied - I just picked the most obvious weakness. But are you aware anyway of just how easy sheet and book level protection are to break? It comes down in the end to - as someone else around here (Hans, I think) said - how malicious your end users are. Most aren't and the really nasty ones will get through anything you throw at them. I tend to protect the sheets and only occaisionally do I lock the project. How far you go comes down (IMHO) to personal preference born from experience.

    Brooke

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sheets VeryHidden (Excel 97/2000)

    I guess I'll protect the sheets just for the hell of it. I agree with everything you said, no denial. I know Excel is not secure (was never designed to be) and there are tons of password breakers on line for the asking.

    I always protect my project though. I spent a year writing this damn thing and the code is intellectual property. I don't even give the admin users the password. If they can't do what they need to do without editng the code then I failed in my job as a designer. They can come to me to add new features, I don't trust them to do it themselves (they're MBAs I'm the techie programmer, that's my job).

    Thnx, Deb <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •