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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CutCopyMode -- What workbook was copied? 1
Macro shortcuts are running macros in different open workbook 3
VBA empties clipboard 3
halt macro execution, inspect progress and then resume execution 1
Command Bar show/hide/delete 1
Workbook_open not executing 1
run macro in another workbook - error 1004 7
Macro to open file and copy information from worksheet 1

Back
Top