View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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