Entering in data in specific cells using range protect or locking the cells

[howard101]

I would like VBA Code that will that will protect the following cells i.e force me to enter cells in the following ranges

A2, A5, A7, C2, D2. When I enter twice after enter data in D2, then macro must end

Your assistance will be most appreciated

Howard
http://www.mrexcel.com/forum/showthr...ghlight=howard

[royUK]

Protecting Cells will not force Input

[royUK]

I think this is what you want

Please Login or Register  to view this content.

[royUK]

Example for above