Hi All,
I'm trying to use the WORKSHEET_CHANGE event to detect a user's alteration of a range in a worksheet, and prevent the saving or selection of a different row until a condition is met.
Trying to do this is getting to be a real pain; after moving the focus back to a cell after the selection changes from a 'dirty' cell, how can I get the worksheet_change event to fire again if the user moves off the row again, can I programmatically make dirty=true? lol...
tyia,
Drew
[sig][/sig]
I'm trying to use the WORKSHEET_CHANGE event to detect a user's alteration of a range in a worksheet, and prevent the saving or selection of a different row until a condition is met.
Trying to do this is getting to be a real pain; after moving the focus back to a cell after the selection changes from a 'dirty' cell, how can I get the worksheet_change event to fire again if the user moves off the row again, can I programmatically make dirty=true? lol...
tyia,
Drew
[sig][/sig]
