Shapes->Drawing Tools->Don't move or resize with VBA

[Dexter666]

Hi Excel 2007 won't record anything with Macro recorder if I switch the option of a Shape to 'Move or Resize'. Is there a way to do it with VBA?

So If I select a shape and then go to Drawing Tools->Tools->Size->Properties and want to switch the option button...

Thank you.

 

[JamesW]

Hi there,

Not 100% sure about Excel 2007, but this works in 2003:

Sheets("Sheet1").Shapes("Oval 3").Placement = xlFreeFloating

 

[Dexter666]

Thank you, it works! Found it in the excel vba help. So the full enumeration is:

Name                          Value        Description 
xlFreeFloating                 3             Object is free floating. 
xlMove                         2             Object is moved with the cells. 
xlMoveAndSize                  1             Object is moved and sized with the cells.

The funny thing about is, that the Version information says:
Version Added: Excel 2007