Ok. Thanks for the response Rob.

"Rob Bovey" wrote in message
...
"Steph" wrote in message
...
Hello, Is it possible to disable the radio button "All" when a user
selects
Paste Special?

All instances of Paste Special are ok, I just don't want them to use
"All".
I have already disabled all "Paste" functionality...just haven't seen or
read anything anywhere about disabling certain buttons within Paste
Special.

Hi Steph,

Unfortunately, I don't believe there's any way to do this. The best
you
can do is disable access to the paste special feature as well and then
create custom menus and/or toolbar buttons to allow the user to perform
the
specific paste special operations that are OK for your application.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm