ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clear clipboard (https://www.excelbanter.com/excel-programming/273434-clear-clipboard.html)

Deer Hunter

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



Tom Ogilvy

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






All times are GMT +1. The time now is 09:25 AM.

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