change cells
I hope someone can help .... Excel 2000
I have a spreadsheet where users need to be able to change values in columns
B:G but not in Column A or H...
I could lock the necessary cells and protect the sheet, however....
The users should be able to delete the enitre row if they wish.
I thought of using the Private Sub Worksheet_Change(ByVal Target As Range)
function - but it executes after the cell is changed. and is there a way to
determine if the cell is being changed or the entire row was deleted?
any ideas?
Thanks
wAyne_
|