View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default 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