|
upload a button image
**** Post for FREE via your newsreader at post.usenet.com ****
Hi guys, Does anyone know how to customize your own button image on the toolbar. I know I can use "Edit button image" or copy and paste an image to a button. But if I use a macro to create the button, how can I also change the image via the macro to my preferred icon ? I have an icon file but don't know how to load into excel and what FaceID I should use if it has been loaded. Thanks in advance. Oliver -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
upload a button image
You do it the same way
use the pasteface method. You have to get your image into the clipboard. Since I don't know anything about you icon file, I can't say how you would do that. Regards, Tom Ogilvy "Oliver Chiu" wrote in message ... **** Post for FREE via your newsreader at post.usenet.com **** Hi guys, Does anyone know how to customize your own button image on the toolbar. I know I can use "Edit button image" or copy and paste an image to a button. But if I use a macro to create the button, how can I also change the image via the macro to my preferred icon ? I have an icon file but don't know how to load into excel and what FaceID I should use if it has been loaded. Thanks in advance. Oliver -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
upload a button image
**** Post for FREE via your newsreader at post.usenet.com ****
Thanks Tom, My image is just a standard icon file .ico, how can I load this into the clipboard ? Do I have to convert it into bmp first ? Oliver "Tom Ogilvy" wrote in message ... You do it the same way use the pasteface method. You have to get your image into the clipboard. Since I don't know anything about you icon file, I can't say how you would do that. Regards, Tom Ogilvy "Oliver Chiu" wrote in message ... **** Post for FREE via your newsreader at post.usenet.com **** Hi guys, Does anyone know how to customize your own button image on the toolbar. I know I can use "Edit button image" or copy and paste an image to a button. But if I use a macro to create the button, how can I also change the image via the macro to my preferred icon ? I have an icon file but don't know how to load into excel and what FaceID I should use if it has been loaded. Thanks in advance. Oliver -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
upload a button image
does Insert=Picture=from file work.
If so, once on the worksheet, you can copy it to the clipboard. If all that works, then you might put it on a hidden sheet and copy from the sheet when you need to use the icon. Regards, Tom Ogilvy "Oliver Chiu" wrote in message ... **** Post for FREE via your newsreader at post.usenet.com **** Thanks Tom, My image is just a standard icon file .ico, how can I load this into the clipboard ? Do I have to convert it into bmp first ? Oliver "Tom Ogilvy" wrote in message ... You do it the same way use the pasteface method. You have to get your image into the clipboard. Since I don't know anything about you icon file, I can't say how you would do that. Regards, Tom Ogilvy "Oliver Chiu" wrote in message ... **** Post for FREE via your newsreader at post.usenet.com **** Hi guys, Does anyone know how to customize your own button image on the toolbar. I know I can use "Edit button image" or copy and paste an image to a button. But if I use a macro to create the button, how can I also change the image via the macro to my preferred icon ? I have an icon file but don't know how to load into excel and what FaceID I should use if it has been loaded. Thanks in advance. Oliver -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
| All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com