View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hbj hbj is offline
external usenet poster
 
Posts: 35
Default On-sheet activeX component disables copy/paste

Hi xlgurus,

I have inserted an ActiveX pushbutton to a worksheet, the position of which follows the selected cell. The corresponding VBA code is triggered by event Worksheet_SelectionChange. The purpose is to make it easier to toggle value in a specific column of selected row. By occasion, when I tested it I found that normal Copy/Paste is disabled. This happens at the very line where I set the position of the control:
ActiveSheet.OLEObjects("cmdSetReset").Top = rngAct.Top

Any ideas...

Hakan