PDA

View Full Version : Change Excel icon



av8tordude
05-09-2011, 11:06 AM
I've search the internet extensively, but can't seem to get a definitive answer...

Is it possible to change the desktop icon in exchange with my jpeg picture inserted on a sheet in a workbook?

Example: Insert jpeg logo on sheet2 and use VBA to change the excel icon to the jpeg logo inserted in sheet2.

Paul_Hossler
05-09-2011, 02:12 PM
Maybe if you can save the JPEG as an ICO file you can use this technique

Even if you can't it's an interesting article anyway


http://www.vbaexpress.com/kb/getarticle.php?kb_id=457

Paul

Kenneth Hobs
05-09-2011, 06:29 PM
If you insert the shape as a proper ICO, there might be a way to do it.

If you have an ICO filename, you can use this method. http://www.java2s.com/Code/VBA-Excel-Access-Word/Windows-API/ChangetheExcelicon.htm