Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing change of a cell value
Hi,
Value in column A determines values in other cells in the same row. I want the user to be warned before changing the value in column A that the contents of the row will be deleted as values in other cells depend on the value in column A. I am using the worksheet change event for this. Unfortunately, this works only after the value in Column A is changed. The code I am using in the worksheet change event is: If Inputsheet.Cells(Selection.Row, 9) < "". Then etc. Here column 9 is selected as the value in column 9 is derived through a series of changes in the intervening columns: all decided by the value in column 1(A). Any help on how to prevent change to cell in column A before changing the value will be welcome. Thanks in advance for the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing a cell value based on change in other field | Excel Programming | |||
preventing a cell from being referenced? | Excel Discussion (Misc queries) | |||
Preventing only one cell from recalculating | Excel Programming | |||
preventing reference to a particular cell | Excel Programming | |||
Preventing cell from being empty | Excel Programming |