CommandbarButton.Execute method not working for drawing shapes
It looks like we've lost some functionality. Even the new ribbon commands
have the same non-result:
CommandBars.ExecuteMso "ShapeFreeform"
--
Jim
"Jeff Abbott" wrote in message
...
| In office 2007 my code I use to auto-execute command bar functions don't
work
| any longer for drawing shapes. Other items like New workbook work fine.
|
| For example, this line of code when executed in the immediate window of
| Excel VBA should draw a freeform shape:
|
| excel.CommandBars.FindControl(,200).Execute
|
| The cursor does indeed change to that used for drawing a freeform
(ID=200),
| and the freeform buttons on the Insert-Shapes ribbon are indeed depressed
| just as they are when you manually initiate drawing by clicking on the
button.
|
| Any ideas? Is the interface being deprecated?
|
| Any help would be greatly appreciated.
|
| Jeff
|