Unlocking range of cells based on condition

[Masa5]

Hello,

can someone please help me do the following. I have a sheet in which some of the data is locked and some isn't. I want to unlock some cells based on a condition:

Book1
	A	B	C	D
3		ColumnA	ColumnB-locked
4	row1	0		ifA1=0unlockB1
5	row2	1		ifA2=0unlockB2
6	row3	3		ifA3=0unlockB3
7	row4	7		ifA4=0unlockB4
8	row5	0		ifA5=0unlockB5
9	row6	2		ifA6=0unlockB6
10	row7	0		ifA7=0unlockB7
11	row8	4		ifA8=0unlockB8
Sheet1

Basicly I want to unlock cells in column B if the number in column A is 0. I have 300 rows (with data) and many sheets (with different numbers, but same columns).

I'm not very good with Macros (know just basics and use them occasionaly).

Would appreaciate all the help.

Regards,

M

 

[onlyadrafter]

Hello,

Is the data in Column A manually entered or are they formulae?

 

[Masa5]

Data in column A is linked from another file.

M