Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Clear clipboard

Hello,

I've got an worksheet from someone.
I had to unprotect the sheet.
And every time I go to another cell, it seems that the clipboard is cleared.
Not very handy, because when I want to copy a cell, move to the destination
cell, the clipboard is empty....
How can I change this? Somebody a solution?

regards, Mike


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Clear clipboard

It sounds like the workbook has event code for the selectionchange event.
Right click on the sheet tab of the worksheet and select view code. See if
there is a selectionchange event in that code module. When a macro runs, it
often clears the clipboard and the undo history as a side effect.

Regards,
Tom Ogilvy


"Deer Hunter" wrote in message
...
Hello,

I've got an worksheet from someone.
I had to unprotect the sheet.
And every time I go to another cell, it seems that the clipboard is

cleared.
Not very handy, because when I want to copy a cell, move to the

destination
cell, the clipboard is empty....
How can I change this? Somebody a solution?

regards, Mike




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
How to clear clipboard memory? Eric Excel Discussion (Misc queries) 2 April 6th 10 06:09 PM
Clipboard empty but still get waring that clipboard is full Steve Excel Discussion (Misc queries) 0 June 17th 08 09:05 PM
Why does it clear my clipboard? Jessica P Excel Discussion (Misc queries) 5 March 19th 08 09:14 PM
Clear Clipboard after Copy Connie Excel Discussion (Misc queries) 2 November 8th 06 07:20 AM
Clear clipboard contents Cordobes Excel Discussion (Misc queries) 4 November 22nd 05 02:41 AM


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

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

About Us

"It's about Microsoft Excel"