Results 1 to 7 of 7

Protect Sheet & Password Protect Code

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    42

    Protect Sheet & Password Protect Code

    I have two basic questions.

    1) I need to have code to protect the sheet that my user form is writing to. In other words, when the information from the user form is populated to the sheet, I want that sheet protected by a password that I set where I can unlock it, but no one else can.

    2) I need to protect my VBA code with a password, I do not know how to do this, I have looked everywhere. I do however think this is something simple and I will kick myself once I find out where it is.

    I will attach my workbook to this post so anyone can reference it.
    Attached Files Attached Files
    Last edited by KLahvic; 05-28-2009 at 02:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1