Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can I set the button properities for "Don't move or size" when I create the
button using VB? I try to use recorder to record the code, but it does not have. Thanks. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On 19 Aug., 08:38, leungkong
wrote: Can I set the button properities for "Don't move or size" when I create the button using VB? I try to use recorder to record the code, but it does not have. Thanks. hi, try ActiveSheet.Shapes("CommandButton1").Placement = xlFreeFloating stefan |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks, Stefan. :-)
"stefan onken" wrote: On 19 Aug., 08:38, leungkong wrote: Can I set the button properities for "Don't move or size" when I create the button using VB? I try to use recorder to record the code, but it does not have. Thanks. hi, try ActiveSheet.Shapes("CommandButton1").Placement = xlFreeFloating stefan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I move and size a picture with a cell but keep the aspect r | Excel Discussion (Misc queries) | |||
Move and size a object on the sheet | Excel Programming | |||
Can the Combo Box move and size with cells radio button be enable | Excel Worksheet Functions | |||
ComboBox move and size | Excel Programming | |||
TextBox Properties -- Don't move and size with cells | Excel Programming |