set some variable to the range you want to copy, like
Set MyVariable = Range("RangeToCopy")
then IN the workbook.Activate, before pasting, copy (again, maybe) by
MyVariable.Copy
THEN paste.

Bob Umlas
Excel MVP

"Michael Malinsky" wrote in message
ups.com...
I have some VBA code that makes a menu item on the standard menu bar
appear/disappear based on whether a certain workbook (MyWorkbook) is
the active workbook. Some of this code is located in the ThisWorkbook
object which then calls other procedures located in Module1. For those
of you that may be familiar, I'm using the code crated by Byg Software.

My question is this. If I am trying to copy/paste something to/from
MyWorkbook, the Workbook Activate event clears the clipboard which
pretty much (well, completely) kills the procedure.

Is there any way around this?

Thanks,
Mike.