Consulting

Results 1 to 10 of 10

Thread: Unviewable projects

  1. #1

    Unviewable projects

    Hi
    For the first time, I've a strange workbook
    When I logged on VBE I found it doesn't open and there's a message (Unviewable project)
    I don't want to hack on it
    But I want to protect my workbooks like this...
    Has anybody encountered like this?

  2. #2
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Most likely password protected. You will need the PW to open it but since you dont there is hundreds of article telling you how to do it. Google it.
    Peace of mind is found in some of the strangest places.

  3. #3
    Thanks ..
    I want to protect my project like the manner I described

  4. #4

  5. #5
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    It's probably protected in a shared workbook, unshare it to be able to unprotect it and view it!
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

  6. #6
    ِMr. Simon
    I don't want to unprotect the workbook
    I want the way that this workbook is created ..
    This is my simple request
    Thanks

  7. #7
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Then i don't understand, you want to leave the vba project locked? if thats the case then it is and thats why you are getting the message, protecting the workbook has nothing to do with protecting the vba project.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

  8. #8
    Hi Simon
    I'm sorry that I can't explain my problem adequately ..
    I attached a file that's protected in the way that I mentioned
    I want to know :: the way that is used to protect the project in this workbook.
    But in details if possible

  9. #9
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Simon he wants to know how to protect his code like in the sample.
    Peace of mind is found in some of the strangest places.

  10. #10
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Thats one of Roy's workbooks, he's probably used a 3rd party application like Lock xls
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

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