Disable Edit > Fill

[TEAM]

I am using the current commands to prevent cut, copy, past, drag, drop, etc. What command would I use to prevent the user from filling up, down, right, etc??

Please Login or Register  to view this content.

Thanks!

[TEAM]

Any ideas on this one?

[Bob Umlas]

commandbars("Worksheet menu
bar").Controls("Edit").controls("Fill").enabled=False

Bob Umlas
Excel MVP

"TEAM" <[email protected]> wrote in message
news:[email protected]...
>
> Any ideas on this one?
>
>
> --
> TEAM
> ------------------------------------------------------------------------
> TEAM's Profile:
http://www.excelforum.com/member.php...o&userid=22810
> View this thread: http://www.excelforum.com/showthread...hreadid=484102
>

[TEAM]

Many thanks for you help!!

[TEAM]

How would I put this in the Workbook open module? I tried as it is written and I get an error...


THANKS!!

[TEAM]

Any Ideas??