Executing Macro Cancels CutCopyMode

  • Thread starter Thread starter Mitch Powell
  • Start date Start date
M

Mitch Powell

I have a macro that removes a workbook specific menu in the
Workbook_Deactivate event. The problem is that if the user wants to copy
information from this workbook into another, the act of flipping to the
target workbook causes the macro to run and this seems to cancel the copy
operation and clear the clipboard. Is there any way around this or am I
stuck with never being able to copy information from this workbook to
another?
 
Doesn't work. It appears that any menu manipulations at all set CopyCutMode
= False
 
Back
Top