bitmap for buttons

S

Sarah Davies

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.
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
XLM Macros: Problems With Custom Toolbar Buttons 0
How to assign macro coding into customized button? 4
Excel buttons change macro file name when run on other computers 7
Macro creation via VBA 26
bitmap for buttons 1
Macro for a 'Go to Top' button 5
Finding the proper style field and the numbered paragraph value within the style 0

Top