ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable Paste Special (https://www.excelbanter.com/excel-programming/333078-disable-paste-special.html)

Steph[_3_]

Disable Paste Special
 
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

Disable Paste Special
 
"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



Steph[_3_]

Disable Paste Special
 
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






All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com