View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default CutCopyMode=False does not work

hi, Horatio !

Your first link about the office clipboard looked good, but it didn't work for me:
Application.CommandBars("Clipboard").Controls(4).E xecute


office clipboard for xl2000, try with:
- Application.CommandBars.FindControl(ID:=3634).Exec ute

I found a comment on another forum that said you can't clear the office clipboard with vba.
I have tried recording a macro for clearing the clipboard, but it just comes up blank.
Instead I have settled for just closing the clipboard:
Application.CommandBars("Task Pane").Visible=False
But since the Task Pane is only in newer versions of Excel

is that line of code going to be an issue for users with an older version of Excel?


office clipboard "moved" to task-pane (xl2002 / xl2003) and AFAIK...
- it does not expose its OM to VBA :-((
- closest approach ?... see Michael Pierrone (post # 6) in: - http://tinyurl.com/2j8y4x

hth,
hector.