VBA to continuously block shaded (Black) cells

[SCHEID53]

Hello all,

Looking for some possible input on how to write a code that protects only black cells. I am new to VBA so my experience is very little, however I do have some experience with Matlab.

Background on Spreadsheet:

The spreadsheet I have made essentially follows a flow chart, when you open the spreadsheet only value in range not formatted black is A1, when you input A1, B1 becomes unformatted (conditional formatting) and so on flowing horizontally, however depending on input may skip portions. I do the sheet protected to leave titles and other info protected already.

From my limited VBA it seems like there may be a way to:

Protect Sheet(titles ect.) + Black Filled Cells
Input in not formatted cell(which un formats new cell, already does this)
Update Protection on Black filled cells
Continuosly

Any help is much appreciated for this newbie!

[daffodil11]

I'd lock all the cells except for the one to begin with.

Then I'd use a worksheet change event to watch for cells that have changed in a certain range, and adjust their .Locked property in a loop.