Results 1 to 1 of 1

Button icon ids for excel 2007

Threaded View

mhoude Button icon ids for excel 2007 11-21-2012, 12:25 PM
  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Button icon ids for excel 2007

    Hi, i reworking someone else macro and actually, i want to add more macros in custom toolbar. The problems is I dont find icon ids so they dont look all the same.


       [Application.CommandBars.Add(Name:="BOM", Position:=msoBarBottom).Visible = True
       Set FormatBtn = CommandBars("BOM").Controls.Add(Type:=msoControlButton, ID:=107)
            FormatBtn.Caption = "Format Data"
            FormatBtn.OnAction = "FormatData"
            FormatBtn.Enabled = True]
    This part work and my new buttons work when i use same ID:=

    Please help me find a link or a better code to change icon

    Thank you
    Last edited by jeffreybrown; 11-21-2012 at 12:29 PM. Reason: As per the forum rules, please use code tags...Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1