Using a macro to protect a sheet after the information update.

[Patrick Antus]

I have a form with 3 tabs on it. There are specific fields that they are
allowed to enter in their time. It is protected right now with a password and
my PMP team will use it to document time for their projects. After the
initial assessment of a project, my team runs a macro that takes the
protection off then deletes the range of cells that they were allowed to
enter their time and protects the entire worksheet. I have created a macro
to lock the entire sheet but I have been unable to protect the sheet using a
password inside of a macro. As the file stand now the customer can click on
tools/protection/unprotect and change any field they want. I created the
macro because my team members are not that excel savy.

 

[Tom Ogilvy]

Activesheet.Protect Password:="ABC"

protects the sheet with a password for me.

Activesheet.Unprotect Password:="ABC"

unprotects it after the password is applied.

 

[Patrick Antus]

Thank you Tom. I needed that "=". Excel help did not come close to helping
but you did.