Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Macro to clear Clipboard

Can't find a way to clear the clipboard using a macro

Thanks
GJ

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Macro to clear Clipboard

Maybe...

application.cutcopymode = false

??

gj wrote:

Can't find a way to clear the clipboard using a macro

Thanks
GJ


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Macro to clear Clipboard

Hi,

This does not work for me. Is there something else I should be looking for?
I'm in Excel 2003.

Thanks,
--
Marc


"Dave Peterson" wrote:

Maybe...

application.cutcopymode = false

??

gj wrote:

Can't find a way to clear the clipboard using a macro

Thanks
GJ


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Macro to clear Clipboard

Chip Pearson has some nice notes at:
http://www.cpearson.com/excel/clipboar.htm
for working with the windows clipboard.

But I don't recall ever seeing application.cutcopymode=false fail in a windows
environment.

Marc wrote:

Hi,

This does not work for me. Is there something else I should be looking for?
I'm in Excel 2003.

Thanks,
--
Marc

"Dave Peterson" wrote:

Maybe...

application.cutcopymode = false

??

gj wrote:

Can't find a way to clear the clipboard using a macro

Thanks
GJ


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Macro to clear Clipboard

How does it fail ?

NickHK

"Marc" wrote in message
...
Hi,

This does not work for me. Is there something else I should be looking

for?
I'm in Excel 2003.

Thanks,
--
Marc


"Dave Peterson" wrote:

Maybe...

application.cutcopymode = false

??

gj wrote:

Can't find a way to clear the clipboard using a macro

Thanks
GJ


--

Dave Peterson





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Macro to clear Clipboard

Nothing happens. I have this - Application.DisplayClipboardWindow = True
to show the clipboard. I've tried Application.CutCopyMode = False before and
after displaying the clipboard and in either case it doesn't clear the
clipboard.

Thanks,
--
Marc


"NickHK" wrote:

How does it fail ?

NickHK

"Marc" wrote in message
...
Hi,

This does not work for me. Is there something else I should be looking

for?
I'm in Excel 2003.

Thanks,
--
Marc


"Dave Peterson" wrote:

Maybe...

application.cutcopymode = false

??

gj wrote:

Can't find a way to clear the clipboard using a macro

Thanks
GJ

--

Dave Peterson




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does it clear my clipboard? Jessica P Excel Discussion (Misc queries) 5 March 19th 08 09:14 PM
VBA Clear clipboard NickH[_3_] Excel Programming 5 November 13th 05 06:02 PM
Clear Clipboard in VB Steve Excel Programming 2 February 26th 04 02:30 PM
Clear Clipboard John McGimpsey Excel Programming 0 February 1st 04 10:14 PM
Office Clipboard: Clear all with VBA-macro? wonder Excel Programming 0 December 18th 03 09:35 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"