Unlocking range of cells based on condition

Masa5

New Member
Joined
Jun 16, 2006
Messages
4
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
ABCD
3ColumnAColumnB-locked
4row10ifA1=0unlockB1
5row21ifA2=0unlockB2
6row33ifA3=0unlockB3
7row47ifA4=0unlockB4
8row50ifA5=0unlockB5
9row62ifA6=0unlockB6
10row70ifA7=0unlockB7
11row84ifA8=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). :oops:

Would appreaciate all the help. :rolleyes:

Regards,

M
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

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

Forum statistics

Threads
1,141,681
Messages
5,707,796
Members
421,529
Latest member
Balintn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top