![]() |
bitmap for buttons
thanks to harold staff for his suggestion, but I need
some lines to put into the macro (which makes the toolbar and assigns the button), which will set the face as "H:\buttons\Macro1.bmp" for example automatically without having to go into the face editor in the customise menu. |
bitmap for buttons
It's right there in the sample file "CommandBars with custom icons"
' insert an icon from a file If CopyPictureFromFile(shtCustomIcons, ThisWorkbook.Path & "\donotpark.bmp") Then .PasteFace ' paste the custom icon End If -- HTH. Best wishes Harald Followup to newsgroup only please "Sarah Davies" skrev i melding ... thanks to harold staff for his suggestion, but I need some lines to put into the macro (which makes the toolbar and assigns the button), which will set the face as "H:\buttons\Macro1.bmp" for example automatically without having to go into the face editor in the customise menu. |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com