Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: visible code but not updatable

    Hi,

    Is there a way to render the code uneditable in excel. I have made my excel application and deployed to to multiple users but I don't want them to to modify the code. The app is locked with a pass. But the user can still access the VB editor and change that code. I am looking for a way to either hide, lock or make the code uneditable. Is that possible? Is so, would anyone know the steps to take?

    Thanks
    Alexx
    PS: Thank you to all who have helpped me so far. Your imput has been extremely valuable.

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by Alexxx12
    I am looking for a way to either hide, lock or make the code uneditable. Is that possible?
    In the Excel VB Editor Select 'VBProject Properties...' Menu 'Tools->VBProject Properties...' Click the Protection Tab on the properties dialog. Check 'lock project for viewing' and set a password. Remember the Password
    ~

    Bill

Posting Permissions

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