LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default adding to Context Menus in Excel 2007

Hi there
We've just upgraded to Office 2007, and Id created some handy chart tools
for my team. Obviously these didnt work first off and had to do a bit of
fiddling to get these to work again!

strangely i thought that problem would have been harder than getting the
context menu items to appear!

In 2003 I was able to Add items to the RMB context menus for Object/Plot and
Plot Area and they would appear without issue.

in 2007 These get added although they arent visible, i can see them when I
run a script to look at all the context menus, but they never appear with the
RMB!
I've not managed to get an answer as to why I can add Context Menu items for
cells but not Charts!

The Script for adding them I used was

With Application.CommandBars("Object/Plot").Controls
With .Add
.Caption = "Chart Tidy"
.OnAction = "BarChartTools.ChartTidy"
.BeginGroup = True
End With

End With


With Application.CommandBars("Plot Area").Controls
With .Add
.Caption = "Chart Tidy"
.OnAction = "BarChartTools.ChartTidy"
.BeginGroup = True
End With

End With

 
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
Adding commands to the Excel 2007 Chart context menu Andreas Charts and Charting in Excel 1 January 23rd 09 08:15 PM
Accessing the excel 2007 context menus... Jimm Excel Programming 2 June 26th 08 02:04 PM
[Excel '03] check-box menu items and cell context menus don't disp Jack Hoxley [MVP] Excel Programming 5 May 2nd 08 05:08 PM
Adding context menu to shapes in Excel 2007 JJ Excel Programming 0 June 2nd 07 12:28 PM
excel 2007 customize quick access toolsbar adding menus commands Søren Thade Petersen Excel Discussion (Misc queries) 3 November 18th 06 04:38 PM


All times are GMT +1. The time now is 05:27 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"