hi,
try this...
CommandBars(1).Controls("Edit").Controls("Fill").V isible =
False

peter

-----Original Message-----
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
.