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 colum
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 t
insert new rows in a protected column but what about excel 2000

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

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/

i understand what you mean but am not sure how to code it. could u hel
me out with it

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

Insert a Form button and use this macro.

Sub Button1_Click()
ActiveSheet.Unprotect
ActiveCell.EntireRow.Insert
ActiveSheet.Protect
End Sub


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


"shirley " wrote in message
...
i understand what you mean but am not sure how to code it. could u help
me out with it?


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

Hi, thx for ur help. the code works. however, i face a problem.
wat happened was i added in this line
ActiveCell.Locked = False
so that i can edit the cell when i add a new line in.
but when i set the whole spreadsheet as protected and i run the
spreadsheet for the first time, if i press the button i get this error
msg, "unable to set the Locked property of the range class". what
should i do?

i need the spreadsheet to be protected right from the start when the
spreadsheet is opened.

pls advice me. thx


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

ActiveCell.Locked should be run before you protect the worksheet.

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


"shirley " wrote in message
...
Hi, thx for ur help. the code works. however, i face a problem.
wat happened was i added in this line
ActiveCell.Locked = False
so that i can edit the cell when i add a new line in.
but when i set the whole spreadsheet as protected and i run the
spreadsheet for the first time, if i press the button i get this error
msg, "unable to set the Locked property of the range class". what
should i do?

i need the spreadsheet to be protected right from the start when the
spreadsheet is opened.

pls advice me. thx


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