Disable Fill Down, Right, Up....
Alas, I am stuck with having users fill out Excel forms to gather
change data. In my blissful ignorance, I validated the cells for dates
and such, so they could only enter what I wanted. However, they have
thwarted me by cutting and pasting incorrect data into my validated
cells.
I figured out how to keep them from pasting into my cells, but am at a
loss to how to disable the Fill commands. I want them all disabled;
up, down, right, left - all of them. Ultimately, I'd like an electric
shock to emanate from the keyboard when they enter something
incorrectly, but I'll settle for disabling the fill function.
Please help.
Thanks,
Verena
|