Just realised one more mistake I was doing as you all pointed out to me
Till now I was working through AllowEditRanges. These work fine even i
the cell is locked. But the controls with linked cells do not work thi
way. They require that the cells are unlocked when you are usin
protection. Thanks to all of you.

Manges

--
Message posted from http://www.ExcelForum.com