Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert worksheet clears clipboard (XL2000 SR1)

    I often try new procedures on part of an existing worksheet using copy, then pasting into a new sheet. If I use select/copy, then add a new worksheet, the clipboard is cleared when the new worksheet is added, so I have to go back and copy the selection again. Is it possible to add a new worksheet without clearing the clipboard? (If you use select/copy then add a new workbook the clipboard is not cleared)

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert worksheet clears clipboard (XL2000 SR1)

    Excel's implementation of the clipboard is very non-standard, and in many cases is a real PITA. Unfortunately, when you copy something to Excel's clipboard, doing almost anything else in the same workbook will clear the clipboard. I do not know of any way around this.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Aug 2005
    Location
    Idaho, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert worksheet clears clipboard (XL2000 SR1)

    A nifty and inexpensive clipboard enhancement called Clipmate will keep your material available to the clipboard, even through a shutdown. It's at www .thornsoft.com

    Ken Barclay

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert worksheet clears clipboard (XL2000 SR1)

    Thanks kb. I had clipmate on my old computer, hadn't moved it over. I thought one of the Lounge VB genii may see a workaround for the problem.
    There are several clipboard extenders, search the Software Finds forum under Smartboard, Clipmate, Yankee Clipper.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •