Custom written "Insert Row" button. The code behind it unprotects, inserts
row, re-protects.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"shirley " wrote in message
...
i need urgent help. i want to protect a column from being over-written.
but at the same time, i want to be able to insert rows into the column
and be able to add values in. how do i go about doing it?

btw, i'm working on excel 2000 and i know only 2002 has the ability to
insert new rows in a protected column but what about excel 2000?


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