Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
On my worksheet, I have dropped a button control from the Forms Toolbar. I have aasigned a macro to the button. The on click event (??) of the button fires the macro properly, and I get the results I expect. However, a cell has to be edited before the button can be clicked. Before the button is clickable, I have to be out of edit mode. In VBA, I cannot find a way to reference this button control. The button is not in a form, its embedded within the worksheet. I would like to be able to exit edit mode when I mouseOver the button. What should I do? Thank you for your help! cdun2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control Box Properties | Excel Discussion (Misc queries) | |||
Command Button Control Properties | Excel Discussion (Misc queries) | |||
I can't find the command button control object in Excel 2007 | Excel Discussion (Misc queries) | |||
Control Properties | Excel Programming | |||
Change Control properties in VBE | Excel Programming |