LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default CommandbarButton.Execute method not working for drawing shapes

Not really my area but I understand chapter 18 of Stephen Bullen's et al.
book discusses it:

http://www.oaltd.co.uk/Excel2007ProgRef/default.htm

based on his comment at the end of this page:


http://www.dailydoseofexcel.com/arch...ers-reference/

--
Jim
"Jeff Abbott" wrote in message
...
| I'm working on upgrading a VB6 application to Office 2007. Is there a
| reference or sample COM Add-in that demonstrates how to integrate with the
| Fluent UI using VB6?
|
| "Jim Rech" wrote:
|
| 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
|
|
|


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change CommandBarButton state not working Dale Fye Excel Programming 0 November 27th 07 01:10 PM
Drawing Shapes on Forms Jason Zischke Excel Programming 1 May 30th 07 04:39 AM
When drawing shapes in excel the shapes keep disappearing Tape Excel Discussion (Misc queries) 1 October 6th 06 04:23 PM
Drawing shapes in a chart ChadTarget Charts and Charting in Excel 1 September 21st 06 09:07 AM
Method 'PasteFace' of objetc 'CommandBarButton' failed Dennis Excel Programming 1 April 29th 06 03:53 AM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"