| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveX ProgressBar - Scrolling Error disables color update | Excel Programming | |||
| Activex component can't create object | New Users to Excel | |||
| Use Office spreadsheet component in a ActiveX dll | Excel Programming | |||
| Spreadsheet component in an ActiveX dll | Excel Programming | |||
| ActiveX component can't be created | Excel Programming | |||
Threaded Mode
