View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Abbott Jeff Abbott is offline
external usenet poster
 
Posts: 5
Default CommandbarButton.Execute method not working for drawing shapes

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