PDA

View Full Version : [SOLVED] Want to use a different icon for an excel file



worthm
02-16-2015, 12:02 PM
Hello,
I'm using Office 2010 and I want to use an icon different than the usual Excel icon. I have an icon in mind and it already has an ICO file name extension. The only way to do it in Excel is to create a shortcut and then change the icon for that. The spreadsheet is a dashboard and I want to use VB to use the icon but I'm not a programmer.

I have attached a picture of the file image but its not an ICO file. I've already converted that image to the ICO file and I need some VB code or some suggestions on how to use the ICO file without creating a shortcut.

Thanks in advance

Zack Barresse
02-17-2015, 03:03 PM
Hi there,

Take a look at these links. There is a KB entry here and multiple instances of code found on a web search. This isn't something typically done because the icons are highly complex and packaged in the Office deployment, so these are mere workarounds.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=457
http://www.mrexcel.com/forum/excel-questions/2201-change-xls-file-icon.html
http://stackoverflow.com/questions/219096/how-to-set-the-taskbar-grouping-icon/219128#219128 (taskbar grouping icon)
http://www.mrexcel.com/forum/excel-questions/510075-change-excel-icon.html
http://stackoverflow.com/questions/5748968/cannot-change-excel-icon-in-taskbar-with-vba

Most of the above will change a specific workbooks icon. This link shows how to change the icon for all Excel windows, even if minimized:
http://www.vbforums.com/showthread.php?285959-Excel-program-icon&p=1670104#post1670104

These are about as good as you're going to get besides changing the icon of shortcuts. Remember, you can always change a folders icon as well.

HTH

worthm
02-19-2015, 01:40 PM
Wow that's a lot to review. Thank you for your help. I'll mark this as solved