Custom Icon for an Excel File

[Guest]

Hi there.

I want to change the default Excel Icon for a single file. How would I do
this?

Thank you for your help in advance

 

[Ian]

I don't think you can. If you create a shortcut to the file, you can select
an icon for the shortcut.

 

[Guest]

Hi Ian,

I have done this already. I have also tried a couple of programs called
"Icon Changers" and they work fine on a single computer. When you try to copy
the file to another computer the change is lost. I have contacted
manufactures to see what kind of help they can offer.

Thank you for your help Ian.

 

[Ian]

Windows will automatically assign the "correct" icon based on file
extension, therefore when you move the file to another PC, any local change
you have made is lost. I don't think you'll be able to do what you want.

 

[Guest]

Hi there.

I want to change the default Excel Icon for a single file. How would I do
this?

Thank you for your help in advance

 

[Guest]

Hi,

Thanks for your question (jpcmaddog). I also have this question to ask. Do
any experties out there can help us (and also everybody who have the similar
qestion to ask)?

Microsoft Access able to do this on the Start up menu... by setting the
Applicaton icon to a bitmap file or .ico file. This icon will appear on the
application... but that icon fle must also included together with the access
mdb or mde files, since it is 'link' icon file.
I wonder why this could not be done in Excel? Till now I'm still looking for
the answer!

Looking ahead for any help in this regard.

Thanks in advance,

 

[Carl Hartness]

I just replied to Badrul in thread
http://groups.google.com/group/microsoft.public.excel.programming/t/489ca14c90895741?hl=en.
The macro I presented there needs to run every time, so I call it in
the Workbook_Open() event handler. The file with the custom icon
needs to move to other PCs with the Excel file.

HTH
Carl.

 

[Guest]

Thanks to U Carl Hartness. Your macro works well! It runs on the first time I
execute the macro. Although, it consist of a few line s of codes, but it is
so helpful and very efficient!