Need To Lock Cell Range Based On Cell Value

[shoey88]

Hi,

I am hoping someone can help me otherwise I may cry,

I have a spreadsheet that has number between 1-20 entered in every cell in column B all the way down to row 15,000

I need to program something in VBA that will look at each number and then lock a certain range in that row based on that value in column B

For example:

In B3 there is the number '5' therefore I would want it to stop the user entering anything between C3 and G3

In B4 there is the number '3' therefore I would want it to stop the user entering anything between C4 and E4

In B12500 there is the number '14' therefore I would want it to stop the user entering anything between C12500 and P12500

I don't want to have to type out programming for each criteria from 1-20 for 15,000 rows!

Please help, much appreciated

Thanks

Jamie

 

[shoey88]

Bump

 

[shoey88]

Still stuck with this - I'm wondering if it is actually possible?

Much appreciated

 

[MarkAndrews]

bump