Function changes when user cuts and pastes

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have a protected worksheet that has a formula that adds
a column of cells representing bills to be paid. When
the bill is paid the user should put the value paid in
another cell and put 0 in the cell that is being
reference by the formula. HOWEVER after much training I
can't seem to stop users from using cut and paste to move
this value. This has the VERY unpleasant effect of
changing the formula to reference the pasted cell. Can I
lock a formula to never change? Or change the paste
command to only paste values in this one workbook only?

(making it an absolute cell does not stop this behavior
because they are not cutting and pasting the formula,
they are cutting and pasting a cell the formula is
pointing to)
 
Hi

You could offer a cell alongside the existing setup that is a 'Paid?' cell,
which puts the correct figures in the correct cells when the user puts in
"Y" based on a fairly straightforward IF formula.
This would cut down the amount of work the user has to do and avoids them
trying to shortcut the job.

Hope this helps

Andy.
 
Thanks for the suggestion, but the worksheet is more
complicated then I discribed and that solution would
really make things a lot more complicated. I was really
hoping for a way to lock the formula (from automatic
changes, as well as user changes).

I'd like to throw the whole thing out and start over, but
I'm bond to keep putting band-aids on it.
 
Back
Top