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

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