ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   add different button images (https://www.excelbanter.com/excel-programming/335519-add-different-button-images.html)

funkymonkUK[_58_]

add different button images
 

any way to use your own customised buttons? do they to be to jpeg or gi
or bitmap files? how to add them office buttons are very limited an
would like to add my own customer made ones

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=39011


Tom Ogilvy

add different button images
 
If you get the image into the clipboard, when you are editing the button
face, there is an option to paste.

You can do it with code as well using the pasteface method. In xl2002 and
later, the commandbarbutton object has picture and mask properties which are
documented in help. You could use a file as your source with this property.
See Office VBA help for details.

--
Regards,
Tom Ogilvy

"funkymonkUK"
wrote in message
...

any way to use your own customised buttons? do they to be to jpeg or gif
or bitmap files? how to add them office buttons are very limited and
would like to add my own customer made ones.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:

http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=390115





All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com