PDA

View Full Version : make a column read only using vba


Anusree
10-12-2010, 03:43 AM
Hi,
I want to make column B of sheet1 as readonly by writting vba code. Is this possible?

Regards,
Anu
Bob Phillips
10-12-2010, 04:40 AM
Cells.Locked = False
Columns("B:B").Locked = True
ActiveSheet.Protect