Results 1 to 3 of 3
  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

    sheet becomes protected on its own (Excel 2003)

    Has anyone ever heard of this problem (in subject line)? I just now had a very frantic co-worker email me asking if I can figure out the password to one sheet in a workbook. As he was perched on a window ledge ready to jump, he said he has no idea how it got protected, he has no code in it (doesn't know anything about VBA), and doesn't remember protecting anything. I've never heard of any mysterious keystroke you could do to protect a worksheet w/o providing some password especially w/o explicitly going to the Tools/Protect menu.

    I was able to easily break the sheet password and mailed it back to him (as he backed away from the open window). Ahhh, one good deed for the day and it's only 9am <img src=/S/clown.gif border=0 alt=clown width=15 height=15>

    Just curious.

    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sheet becomes protected on its own (Excel 2003)

    I don't think it's possible to protect a worksheet AND provide a password all by accident. It might just be possible that the worksheet became corrupted in such a way that it appeared protected, but frankly, that seems very improbable to me.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> My guess would be that the user had been playing with Tools | Protection and was too embarrassed to admit it...

  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: sheet becomes protected on its own (Excel 2003)

    Yeh, I suspect that too but he then said he had just installed that Acrobat tool bar thingy (that creates PDF files) and that's when things happened. He says that the tool bar doesn't work either. I told him there are some problems with the PDF tool bar and Adobe has some fixes for it but I don't know of how it relates to mysterious protecting of a worksheet. Weirder things have happened - it is an add-in with VBA in it after all.

    Thnx,
    Deb

Posting Permissions

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