Protection and Macros...

T

TyeJae

I want to have my sheet protected where it prompts for a password but i
just gives me an error, here is what I have.

Private Sub CommandButton1_Click()
ActiveWorkbook.Unprotect
Sheets("Requests").Visible = True
Sheets("Requests").Select
Sheets("Main").Visible = False
End Sub

When it tries to Unprotect it does not ask for a password it jus
errors. Am I missing something?

TyeJa
 
Top