Thread: Don't move or size the button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
stefan onken stefan onken is offline
external usenet poster
  
Posts: 33
Default 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
Reply With QuoteReply With Quote