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

Hi,

I have a worksheet that has macros that run on workbook activate/deactivate.

The problem with this is that when I try to copy into or out of this
workbook, I lose the clipboard when I switch to or from the workbook.

Is there a way to save the clipboard before running each of these macros so
I can still paste afterwards?

Thanks,

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

No, but perhaps you could disable events before you do this.

--
Regards,
Tom Ogilvy

"Iain" wrote in message
...
Hi,

I have a worksheet that has macros that run on workbook

activate/deactivate.

The problem with this is that when I try to copy into or out of this
workbook, I lose the clipboard when I switch to or from the workbook.

Is there a way to save the clipboard before running each of these macros

so
I can still paste afterwards?

Thanks,



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
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? Subu Setting up and Configuration of Excel 0 May 5th 09 01:20 PM
Saving clipboard image as BMP through VBA in Excel Elliot Excel Discussion (Misc queries) 0 September 17th 08 03:22 AM
Clipboard empty but still get waring that clipboard is full Steve Excel Discussion (Misc queries) 0 June 17th 08 09:05 PM
macro help - closing without saving & empty clipboard Bry Excel Discussion (Misc queries) 3 November 23rd 06 02:45 PM
Saving clipboard Items Bill Toothaker Setting up and Configuration of Excel 6 July 13th 05 09:10 PM


All times are GMT +1. The time now is 03:15 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"