Disable Paste Special

[Steph]

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.
Thank you!!

 

[Rob Bovey]

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

 

[Steph]

Ok. Thanks for the response Rob.

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