PC Review


Reply
Thread Tools Rate Thread

command bars in charts

 
 
bshumsky06@yahoo.com
Guest
Posts: n/a
 
      21st Nov 2006
Hi,
I would like to modify some of the right click command bar menus in
charts. The following code runs without errors and modifies some of
the command bars (specifically Series and Plot Area and Inactive
Chart) but not the others. Do I have to unprotect something to modify
the others?

Thanks,
Bob




For i = 1 To 10
If i = 1 Then commandBarName = "Series"
If i = 2 Then commandBarName = "Plot Area"
If i = 3 Then commandBarName = "Floor and Walls"
If i = 4 Then commandBarName = "Trendline"
If i = 5 Then commandBarName = "Chart"
If i = 6 Then commandBarName = "Format Data Series"
If i = 7 Then commandBarName = "Format Axis"
If i = 8 Then commandBarName = "Format Legend Entry"
If i = 9 Then commandBarName = "Format Legend Entry"
If i = 10 Then commandBarName = "Inactive Chart"



Set cb = CommandBars(commandBarName)
Set cbc = cb.Controls.Add
With cbc
.Caption = commandBarName & " Menu "
.TooltipText = "very cool"

End With

Next

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bars in Bar Charts in an order =?Utf-8?B?TGlu?= Microsoft Access Reports 3 27th Jul 2007 02:56 PM
Floating Bars on Line-Bar Charts? jaygreg Microsoft Excel Charting 8 19th Jul 2007 03:06 PM
VBA for setting max value in scroll bars on charts? Bob@1800-mail.com Microsoft Excel Charting 3 26th Jul 2006 10:32 PM
widen bars and bar charts breinerb \(removethis\) @cliu.org Microsoft Excel Charting 1 25th Feb 2004 04:35 PM
Re: Charts with bars and lines Bernard Liengme Microsoft Excel Charting 0 25th Sep 2003 08:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:44 PM.