bitmap for buttons

  • Thread starter Thread starter Sarah Davies
  • Start date Start date
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.
 
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
 
Back
Top