Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change button image | Excel Discussion (Misc queries) | |||
how can I paste an image to a button in XL2003 | Excel Discussion (Misc queries) | |||
Paste Button Image | Excel Discussion (Misc queries) | |||
Toolbar Button Image Question | Excel Worksheet Functions | |||
change tool bar button image | Excel Discussion (Misc queries) |