I m making one AddIns for Excel. I have added a CommandBar. Now I can assign the ICon to CommabBar Using Pasteface method. But this is creating some Problem for me. So is there Any other way to assign Icon to Commandbar...
Commandbar ICon (Excel VBA )
Hot Topic
- [Excel] How to convert Excel to jpg, gif image?
- WSS 3.0 Integration with Declarative Workflow
- VBA code for use in several worksheets in a workbook
- response.setHeader in IE
- Solution for Getting from Cell to Cell
- What is the difference between Excel Dates and VBA Dates ?
- ListParagraphs collection in table
- Order By DateDiff() in Access Report
- Problems with last 2 parts of code?
- The specified module could not be found??
Microsoft ISV
- How Can I Do This With Outlook 2000 Calendar?
- Microsoft....Is this a joke? (email received from customer service at microsoft)
- Sum of hours using select statement & VBA
- error in formula
- Browse hard disk with VBA
- trapping 1004 Error when Excel VBA invokes Application object in Internet Explorer
- Log in with Active X
- RefreshLink Method Disables 'Add New Record' Capability to Linked SQL Table
- MS Office document and image writer print driver
- Error 1004 setting print_area
Commandbar ICon (Excel VBA )
gooon
You don't describe the problems you are having, so it's hard to make a sensible suggestion.
In later versions of Office (2003 and perhaps 2002), you can modify the picture and mask propery of the button. In earlier versions you are stuck with pasteface, but you may be able to improve the quality of your image.
The picture and mask technique is described in Professional Excel Development by Bullen, Bovey, and Green. This book is a must-have for any serious Excel developer.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
dube_1969
Hi,
You can use the FaceID property of the command bar item to display an icon. You have to use the built in Excel icons but there are quite a few to choose from. You can get add-ins for Excel for viewing the Icon associated with the FaceID. Have a search and see what you see.
Hope that helped.