ExcelBanter - Don't move or size the button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Don't move or size the button (https://www.excelbanter.com/excel-programming/415845-dont-move-size-button.html)

leungkong

Don't move or size the button

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.

stefan onken

Don't move or size the button

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

leungkong

Don't move or size the button

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

All times are GMT +1. The time now is 02:56 AM.