insert rows needs to copy formula

  • Thread starter Thread starter Mark J Kubicki
  • Start date Start date
M

Mark J Kubicki

problem:
user inserts a row into an existing table,
the insertion does not copy the formula from the row above (and below)

the integrity of the table is gone
....there's got to be a way?
---> isn't there some sort of on insert_row event code that I could use to
trigger a
"code line to copy from ..." to the target row?

the user will need to be able to insert rows, so locking them out of that is
not an option
and
about training users to "learn to copy the formula..."; well, I hate to say
it, but some folks (esp. upper management, and owners)
are NOT trainable...



HELP !!!

thanks in advance,
mark
 
Back
Top