Don't move or size the button

L

leungkong

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.
 
S

stefan onken

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.
Click to expand...

hi, try

ActiveSheet.Shapes("CommandButton1").Placement = xlFreeFloating

stefan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Anchor issue with inserting a shape for letterhead 1
The Placement property does not seem to be working. 6
form buttons on sheet collapse on unhide - sometimes 5
Adding data to MS Access from csv file 0
Text in note pane of "normal" display suddenly much larger 1
Reduce image size 0
"The operation cannot be performed because the object has been deleted." 0

Top