Macro to Prompt for Password for Worksheet Protecton

[spurs]

I am creating a macro is supposed to password protect a worksheet and then hide it.

I recorded the macro including entering a password. When I went to test the macro, it protected the sheet without setting a password at all.

I dont care if I have to manually enter the password or if it uses the password that i put in the macro, but at this point it doesnt password protect at all.

Anyone have any thoughs on how to correct this?

 

[Datsmart]

Your code can include a password like this.

        ActiveSheet.Protect "mypassword"

or this.

        ActiveSheet.Unprotect "mypassword"

Where mypassword is the text of your password.

 

[spurs]

Thanks for the help.