| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I move an ActiveX control (command button) in a worksheet?
I have an existing workbook with several Macros and command buttons. I have
hidden some columns in order to make the spreadsheet more readable but now two of the buttons are overlapping. How can I move the buttons or make them "free floating" so they aren't 'attached' to specific cells (I found the code for making it free floating but I don't know where the code needs to go because I can't find where the command buttons are defined in the code). I have limited experience with macros and VBA. Many Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I move an ActiveX control (command button) in a worksheet?
Right click on the button|Size and properties|Properties| Check the 3rd
option Dont move.... If this post helps click Yes --------------- Jacob Skaria "Bridget" wrote: I have an existing workbook with several Macros and command buttons. I have hidden some columns in order to make the spreadsheet more readable but now two of the buttons are overlapping. How can I move the buttons or make them "free floating" so they aren't 'attached' to specific cells (I found the code for making it free floating but I don't know where the code needs to go because I can't find where the command buttons are defined in the code). I have limited experience with macros and VBA. Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create control button on worksheet: Forms v. ActiveX feature? | Excel Discussion (Misc queries) | |||
| ActiveX command button | Excel Programming | |||
| command button move worksheet from one workbook to another | Excel Programming | |||
| ActiveX Control Button | Excel Programming | |||
Hybrid Mode
