VBA and Password Protection
 

I would like to protect worksheets with a password using a macro. Recording
the macro does not seem to install the password and the worksheet can be
unprotected. What needs to be added to the VBA code?

Thanks,

VBA and Password Protection
 

worksheets("somesheetnamehere").protect password:="topsecret"

Todd from Gold River wrote:

I would like to protect worksheets with a password using a macro. Recording
the macro does not seem to install the password and the worksheet can be
unprotected. What needs to be added to the VBA code?

Thanks,

--

Dave Peterson