M
Michael Malinsky
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.
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.