With Worksheets("Sheet2")

.Unprotect Password:=MyPassword

' do your stuff

.Protect Password:=MyPassword

End With
--
jb


"sam" wrote:

Hi All, I have designed a userform which accepts inputs and the inputs are
stored on Sheet2 of the same work book. Is there any way I can password
protect Sheet2 and still receive userinputs from userform in Sheet2?

Thanks in Advance