I used the following vb code to protect the active worksheet with a password and it works. xyz is my example password.

ActiveSheet.Protect Password:="xyz"
BUT, I have one cell that is not proctected and when I run this code, it protects all of the cells, even the one that I have formatted as Not Protected.

Can anyone give me a lift. I think I need a different way of protecting the activesheet.