Newbie at Vb need help

[MinionMan63]

I have 3 cells that have a macro to change values via a command button and ctrl + R and ctrl + D. Those values change color as well with conditional formatting so you can see the change. How do I lock those cells with out getting a Vb error "1004". At which time I need to reboot pc. Basically I need to lock the cells so you do not damage the values or change the values, then unlock them so the macro can run and then re lock them. If you lock the cells using the format cells properties, then that is when I get the error code. Is there a way to unlock the 3 cells and allow the change then re lock them after they change value.

 

[Rick Rothstein]

If I am understanding correctly, you are protecting the worksheet (after locking the cells) and then getting that error when you try to modify the cells using VBA code. If that is correct, then it means you did not unprotect the worksheet within your code prior to trying to change the cell. The worksheet object has an Unprotect method that you need to call. For example...

Sheets("Sheet1").Unprotect

The Unprotect method can take an optional password argument if you protected the worksheet with a password. After making the changes you want, reestablish protection...

Sheet("Shee1").Protect

Again, you would provide a password if you wanted the sheet to be password protected. You should check the help files for the Protect method as you can tailor the type of protection via code in the same way as you can do with the protection dialog box.