views:

564

answers:

1

I've got an Excel 2007 VBA script that adds a button to the ribbon, but unfortunately the icon is tiny. I tried several different FaceId's, but they all seemed to add tiny icon buttons. Is there a way to load in some of the newer 2007 size icons?

Here is a snippet of the code that I've got loaded in ThisWorkbook:

Set NewButton = NewToolbar.Controls.Add(Type:=msoControlButton)
With NewButton
     .FaceId = 752
    .TooltipText = "Convert XLS Files to CSVs"
    .OnAction = "XLSTOCSV"

Thanks for any insights about increasing the size of the icon.

A: 
TerrorAustralis
Bummer...I guess I was hoping that there existed a way to load the larger default icons within Excel 2007 or to have have it autosize to fill the whole available area by default...oh well...
JustADude
If you want it to fill the whole available area then just set the height and width to be the same as the container's height and width. As far as defining a 'default', why not create some default sizes or a default button to coppy off. Give me a minute tho, i think there is a 'copy template' funciton
TerrorAustralis
See edit for possible solution
TerrorAustralis