View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default Save Copy or Cut Reference

When a macro or an event is run, often CutCopyMode is set to FALSE (lost).
Has anyone put together any code that saves this information? I'd like to
wrap my existing Worksheet_Activate event with something that saves or
re-enables CutCopyMode with the previous reference so that users can bring
data into a new form.

Thanks,
Matthew Pfluger