Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,297
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm not even sure this is possible, but if it is then I'm hoping someone can give me the answer.
I've created a spreadsheet which has a dynamic right-click menu which changes to show the breakdown of overall figures in specific cells in my workbook.
A highly simplified example of the code used to add the caption is:
What I'd like to be able to do is show the figures (18 and 15) in bold on the menu and possibly have the 18 figure in red if it's under the target and green if it's over target.
Forgot to add in my original post that I'm using Excel 2002.
Any help would be greatly appreciated & many thanks in advance.
Update: I've had a reply saying that though I can change the buttons and case of the text, I can't change the colours etc.
As the colour is changed when a option is disabled (greyed out) I might be able to do it using the API.... anyone know anything about API's?
Delmar
I'm not even sure this is possible, but if it is then I'm hoping someone can give me the answer.
I've created a spreadsheet which has a dynamic right-click menu which changes to show the breakdown of overall figures in specific cells in my workbook.
A highly simplified example of the code used to add the caption is:
Code:
Public Sub BuildMenu()
Dim objCmdBarCtrl As CommandBarControl
Dim objCmdButton As CommandBarButton
Set objCmdBarCtrl = Application.CommandBars("Cell").Controls.Add _
(Type:=msoControlPopup, Before:=1)
objCmdBarCtrl.Caption = "Figures for December 2005"
objCmdBarCtrl.Tag = "Scorecard"
Set objCmdButton = objCmdBarCtrl.Controls.Add
objCmdButton.Caption = "Specialism - 18 / Target - 15"
End Sub
What I'd like to be able to do is show the figures (18 and 15) in bold on the menu and possibly have the 18 figure in red if it's under the target and green if it's over target.
Forgot to add in my original post that I'm using Excel 2002.
Any help would be greatly appreciated & many thanks in advance.
Update: I've had a reply saying that though I can change the buttons and case of the text, I can't change the colours etc.
As the colour is changed when a option is disabled (greyed out) I might be able to do it using the API.... anyone know anything about API's?
Delmar