Can't view password protected code
Can't view password protected code
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.

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
  •  

 

 
DMCA.com