Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button not showing graphic.
I have a menu bar that I'm creating as soon as a worksheet is opened. But,
once it's open, the graphic for the button doesn't show up until I actually place my mouse over it. Is this a problem with the coding I'm using, or is it something else that is causing it. Here is the code that I'm using to create the menu bar: Sub PriceToolBar() Dim cbrCommandBar As CommandBar Dim cbcCommandBarButton As CommandBarButton On Error Resume Next Application.CommandBars("Pricing").Delete Set cbrCommandBar = _ Application.CommandBars.Add With cbrCommandBar .Visible = True .Position = msoBarTop .Name = "Pricing" .Left = 100 End With With cbrCommandBar.Controls Set cbcCommandBarButton = _ .Add(msoControlButton) With cbcCommandBarButton .Style = msoButtonIconAndCaptionBelow .FaceId = 275 .TooltipText = _ "Prospect Pricing" .OnAction = "Prospect" .Tag = "Prospect" End With End With cbrCommandBar.Visible = True NewToolBar End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resize my worksheet-there is no maximize button showing | Excel Discussion (Misc queries) | |||
Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
Folder Graphic (in Word & Pub) instead of "Close" button in Excel | Excel Discussion (Misc queries) | |||
Mouse-Over State on Graphic Button | Excel Programming | |||
Showing a .PDF From Excel Button Using VBA | Excel Programming |