I am trying to create an approval button for my manager that will show the date of the approval and his name along with protecting the cells so they cannot be changed. He would also like the protected cells to be password protected. So far I have a short VBA program that will enter his name and the date he approved the work. I am stuck on the protection aspect of the program, the best that I can do is protect the entire work sheet not the individual cell with a password. I have included the VBA program that I have developed so far.
Any help would be greatly appreciated.
Private Sub ApprovelButton1_Click()
.Cells(7, 5) = Date
.Cells(7, 6) = "John Doe"
Thanks in Advanced.