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.

1) See VBE Help for the Protect and Unprotect methods

2) From the VBE, Tools, VBAProject Properties, Protection tab

You need to open the VBE and look at Help there, not from Excel.

i use this, which is inserted into the workbook object in vba, works brilliantly and will only allow users to change the areas of the sheet that you specifically unprotect through "menu - format, cells,protection tab". it will password protect the whole workbook, only downside i've found is that to change anything you need the password for every sheet individually

Private Sub Workbook_Open()
Dim wSheet As Worksheet

    For Each wSheet In Worksheets
        wSheet.Protect Password:="Secret", UserInterFaceOnly:=True, AllowFormattingCells:=True, DrawingObjects:=False, contents:=True, Scenarios:=False
Next wSheet

End Sub

jimbo,

Please edit your post to add code tags.