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: 1
Default display correct toolbar icon on starting excel application program


following is the code which creates toolbar buttons.
I m using office xp 2003. When i start excel program, it doesnt display
correct toolbar icon for which i hv given face-id. But when i move my
mouse over the button, then it changes to the correct one.



Code:
--------------------

Sub CreateBar()
Dim oBar As CommandBar
Dim oKicker As CommandBarControl

RemoveBar 'Prevents duplicate entry

Set oBar = Application.CommandBars.Add(Name:="SKicker", Position:=1, Temporary:=True)
oBar.Visible = True
Set oKicker = oBar.Controls.Add(ID:=1, Befo=1)

With oKicker
.OnAction = "General.Show_SuperKicker"
.FaceId = 9744
.Caption = "SUPERKICKER"
End With

Set oKicker = Nothing
Set oBar = Nothing

End Sub

--------------------


I need to display correct toolbar-icon when excel program is started.
Also some face-id doesnt work with office-2000-- why so?? It gives
debug msg.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=378265

 
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
Icon Sets - Display icon in one cell depending upon value in anoth Nolene Excel Worksheet Functions 2 February 26th 10 05:43 AM
excel keeps crashing when starting the program jblake48 Excel Discussion (Misc queries) 1 October 11th 06 05:19 PM
Starting another program out of Excel VB?? Mac Lingo Excel Worksheet Functions 1 June 16th 06 03:52 AM
Email Icon on excel 200 toolbar a vecin Excel Discussion (Misc queries) 1 April 27th 06 07:31 PM
Can I add equation editior to my toolbar in EXCel as an icon? happy Excel Worksheet Functions 1 October 16th 05 05:32 PM


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