Executing Macro Cancels CutCopyMode

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?
 
P

p45cal

Mitch said:
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?
Click to expand...
If you can cope with the workbook specific menu still being present in
the destination workbook then move the macro from the
workbook_deactivate event to the workbook_beforeclose event?

Perhaps another solution: can you just hide that menu/portion of a
menu, rather than removing it, in the workbook_deactivate event, and
remove it altogether in the worbook_beforeclose event? In the hope that
just hiding (.visible = False?) won't clear the clipboard.
 
M

Mitch Powell

Doesn't work. It appears that any menu manipulations at all set CopyCutMode
= False
 
Top