Possible to stop clearing the Excel clipboard when a macro runs?

[mcomp72]

On several of the sheets in my workbook, I have code that runs inside the Worksheet_SelectionChange sub. This is because I want the font color in column A to change based on what row the active cell is on. (If they active cell is in row 30, the font color in "A30" should change to red.)

Unfortunately, due to this code running every time the user selects a new cell, the clipboard is also cleared, so the user cannot do a copy/paste on the sheets. They can select Copy (or Ctrl-C), but once they move to the cell where they want to paste, the marching ants disappear and the clipboard seems to be cleared. Is there any work-around for this? I would like my users to still be able to copy & paste, but so far the only way I can see to do this is to remove the sub Worksheet_SelectionChange.

 

[igold]

It would be helpful to see your code.

 

[mcomp72]

I'm confused. I thought the Excel clipboard was cleared every time a macro ran. If that's true, I don't understand how seeing my specific code would make any difference.

Is it not always the case that the clipboard is cleared whenever a macro runs?

 

[igold]

If that is correct, then I apologize, I have never heard that before. In that same line of thought, if that is true, there may be code to be written that will save the contents of the clipboard prior to deletion and then write the contents back to the clipboard.

Either way, your choice. I am learning everyday. Perhaps one of our more knowledgeable members will respond with what really happens to the contents of the clipboard when a code is run.