Hi there,

What I would like is that when Each Group has Finished Inputting Data
and Clicks the Finished Button, the Cells with Data in ( Range
"C4:H6"
) Become "Locked". Once the Finished Button is Clicked I do NOT want
them to be Able to Change ANY Previous Data Entered.

This does the trick:

Single cell:
Cells(1, 1).Locked = True

Range:
Range(Cells(1, 1), Cells(10, 10)).Locked = True

Needles to say the other possible argument is: False.

Tip: Try recording a macro while performing the desired actions
manually, then check the code window, so you learn programming on the
fly!

Regards,
ManualMan
www.gamesXL.tk