G
GMet
I have an ID number that is automatically calculated/constructed from values
in other fields. When the user adds a row, the formula is automatically
added and the ID number calculated for the added row. However, when the
user deletes a row, I get #REF! in the cell. I have a menu option that
allows the user to recalculate all the ID numbers when this happens - but
they often forget. I would like to remove the menu item and have the app
recalculate automatically when the user deletes a row so they don't have to
think about it.
If I put "call RecalcID" in the workbook SheetChange event or the
SheetCalculate event, I get an endless loop because each time RecalcID is
run, it changes the workbook.
How can I run RecalcID only once when the user deletes a row?
TIA
GMet
in other fields. When the user adds a row, the formula is automatically
added and the ID number calculated for the added row. However, when the
user deletes a row, I get #REF! in the cell. I have a menu option that
allows the user to recalculate all the ID numbers when this happens - but
they often forget. I would like to remove the menu item and have the app
recalculate automatically when the user deletes a row so they don't have to
think about it.
If I put "call RecalcID" in the workbook SheetChange event or the
SheetCalculate event, I get an endless loop because each time RecalcID is
run, it changes the workbook.
How can I run RecalcID only once when the user deletes a row?
TIA
GMet