Unlocking/Locking Cells with a button

1. Select all of the cells that need to be unlocked for the data entry person (hold down the CTRL key to select multiple non-contiguous cells).

2. Select Insert > Name > Define from the menu, and give this range a name (i.e. DataEntryCells) and click OK.

3. Create 2 command buttons from the Control Toolbox tool bar.

4. Double-click the button to unlock only the certain cells for the data entry person, and copy the following code to the VBE window (change the password in quotes to your password):

Please Login or Register  to view this content.

5. Double-click the button to lock all cells, and copy the following code to the VBE window (change the password in quotes to your password):

Please Login or Register  to view this content.

For each of the two command buttons, you can right-click and select Properties to change the name, etc. Be sure to change the TakeFocusOnClick property to false for both.

HTH

Jason

Edit: looks like I type too slow.

Wow thanks for the quick replies!!

It works!

Is there anyway though to make it so that the other people viewing the sheet cannot click the buttons? Or it prompts you for the password to unprotect the sheet.

I'll be the only person with the password - I just don't want the people who are approving the sheet to be able to go and alter the information the data entry person put in.

Thanks for all your help!!

On the unprotect line, delete the password and quotes. I would think you only need to do this for CommandButton1, as CommandButton2 will only lock everything.

Sweet thanks again!

I had also found this code that worked - was found from this thread

HTML Code: 

Please Login or Register  to view this content.

I'll use yours though as it seems less complicated!!!

Thanks again!

Glad it helped.

Jason