1

I have a sheet, and a button on it (Excel forms button, not ActiveX). Depending on current selection, the button is moved/resized or made visible/unvisible (handled by Worksheet_SelectionChange event). All this was designed in Excel 2010 and worked fine until some end users reported errors while using the workbook in Excel 2007. The issue is, that when you copy/cut a range, and then change selection CutCopyMode is reset to False (floating frame around what was copied disappears). This does not happen in Excel 2010. I found out CutCopyMode is reset when I programatically modify button properties (top, height, left, visible, backcolor are modified each cancels CutCopyMode). Do you have any ideas how to solve this?

Community
  • 1
  • 1
avb
  • 1,743
  • 1
  • 13
  • 23

1 Answers1

0

Following the logic here, it seems that you will need to keep track of the range on the clipboard before modifying your button, and then recopying/recutting after modifying your button to restore the original range to the clipboard.

Community
  • 1
  • 1
Degustaf
  • 2,655
  • 2
  • 16
  • 27
  • Although I expected some way for CutCopyMode not to be canceled, the way you suggested seems to be the only one. Thanks – avb Dec 12 '14 at 02:36