Add button to excel that is able to lock/unlock certain cells

[excelnewbie132]

Hi there!

I am new to this site and pretty much anything macro related.

I have a spreadsheet that I am trying to add a button and want it to have a macro on it that can lock/unlock the sheet or certain cells. I know that you can go to the "Review" tab and then protect the sheet or workbook from there, but I have a reason why I want a button.

This spreadsheet has a ton of formulas in it, and is going to be used by myself and many coworkers and then we will send to a client. I want my coworkers to be able to edit certain cells and then lock those cells before sending to the client. The reason I want a button is to make it as easy as possible for my coworkers to lock and remember to lock the cells before sending to clients. The button would help for those who don't know how to get to the protect sheet area on the review tab or forget, etc. Not everyone is excel savvy

Is this possible to do?

Thank you!

 

[mrshl9898]

Hi,

It's simple enough. What exactly needs to be done, will you already have it setup ready to lock?

Just add a button or picture, and assign macro. Code as follows

Sub UnProtect()


Sheets("Sheet1").UnProtect Password:="myPassword"


End Sub


Sub Protect()


Sheets("Sheet1").Protect Password:="myPassword"


End Sub