Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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_ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change results , change data in othe cells across the row | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions |