Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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
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
resize my worksheet-there is no maximize button showing dj95 Excel Discussion (Misc queries) 3 April 9th 10 07:47 AM
Inserting a Graphic on a Button when the Button is Assigned to a M smck Excel Discussion (Misc queries) 2 October 27th 09 04:46 PM
Folder Graphic (in Word & Pub) instead of "Close" button in Excel Susan ARC Excel Discussion (Misc queries) 1 September 3rd 06 04:34 AM
Mouse-Over State on Graphic Button TheVisionThing Excel Programming 6 November 18th 05 05:17 AM
Showing a .PDF From Excel Button Using VBA Joey[_3_] Excel Programming 2 February 25th 04 11:57 PM


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

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

About Us

"It's about Microsoft Excel"