Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Can't view password protected code

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Ireland
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a file which contains some VBA. I password protected it so that nobody could change it. When I tried to view the code on somebody else's PC, I got an error that the project was unviewable, it didn't prompt me for the password. Why? I need to do this on somebody else's PC as they need to specify a password contained in the code for protecting the workbook and I don't want to know the password they're going to be using. So they need to enter it.

    Please help... anybody

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One reason could be that you protected the code using XL 2000 (or higher) and tried to view it using XL 97. 97 used a different encoding system for VBA password protection (for "different", read "weaker") I believe that XL 2000 has the backward compatability to use the XL97 system, but not vice versa. I really hope this makes sense, I'm tired.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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