Need Help to Create Excel Sheet Checklist !!!

Hello,
I need to create an excel checklist,
So that, if first check (cell) is not ticked then all other checks (cells) will be grayed out and locked,
If first check (cell) is ticked, second check (cell) will be unlocked and color will become normal,
if second cell is ticked, third will unlocked and so on.

I'm new to VBA, please help!!!!
here I'm attaching my excel sheet, you will understand what kind of checks and conditions I want.

Thanks in Advance.

Try something like:

Please Login or Register  to view this content.

You can use conditional formatting to "grey out" the rows that are not yet ticked. See attachment for a worked example.

Originally Posted by LeoTaxi

I was thinking like this

Please Login or Register  to view this content.

Kind regards
Leo

You are amazing bro, this is what I need.
One more thing I wanna ask, Is there any way to change 1, 0 and -1 to Yes, NA and No respectively.
And, Is there any good study materials available for vb/vba. I'm beginner.

Originally Posted by LeoTaxi

This for Yes No NA

Please Login or Register  to view this content.

for the studie material, I used and use google and a lot of practise

Kind regards
Leo

Thanks again brother,
But after this code, tick is no longer there. It simply put text Yes/NA/No.
Check my excel sheet.

And is there any way to assign different colors to Yes, NA and No Rows.

Regards
Sagar