J
Jeff Abbott
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
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