Creating a button to lock specific cells

[RexaZii]

The problem I'm facing is giving me a headache.

First of all, let me give you a brief idea of what I've done:

I locked all the cells by "protect sheet" option, and checked the "select unlocked cells" option.

But there's a specific cells that I want the users to fill and use, so I went to format cells - protection - unchecked the "lock" checkbox.

Whats the problem?

Simply, I want to create a multi buttons, each of these buttons responsible of locking specific area of cells. Its important that the users are not able to select the cells or unlock it after the button is pressed, unless they have the password I put.


I put this code, but its not working:

Please Login or Register  to view this content.

thanks.

[6StringJazzer]

Please explain what "not working" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

I also note that you have not implemented a password, as your description mentions.

[RexaZii]

I meant by not working, is not doing its job that I want it to do. I have put the code but it does not protect the cell after I press the button. Also, the code doesn't show any error messages.
PS. I didn't write the code, I copy pasted it.

[6StringJazzer]

This code works for me. Please attach the file that has this code.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[RexaZii]

I have attached an example of the excel file I'm working on.

as you can see in the excel sheet, each area has a submit button that I want when I press it to lock the white cells with password and make users unable to select it or edit it.
the sheet is also password protected, the password is " 123 ".

thanks.

[6StringJazzer]

There is no code in this file. What cells do you want to lock?

Also, you are using merged cells which is not a good practice, and likely to cause problems in code.

[6StringJazzer]

OK, I think I see what you are doing.

This version locks the cells but allows selection.

I redesigned your form to eliminate merged cells but it still looks the same.

[RexaZii]

This's not what I want, but thanks for your effort though.

What I wanted is to make the whole sheet locked for editing or selection except certain cells. and there's a button when pressed it locks those certain cells. I don't want the user to play with the format of the worksheet accept in his fill-out area, and after he finishes and press submit his area get locked so the next person to fill won't be able to edit the previous person area.

[KOKOSEK]

Do you think about something like this:

Please Login or Register  to view this content.

EDIT: I did not check that 6StringJazzer suggest the same (similar) solution.