tags:

views:

47

answers:

1

In Excel VBA I can use

application.Caption = "mytitle"

to change the title of the Excel session. I want to be able to go one step further and actually change the Excel icon to an icon of my own choosing. Can this be done? Please help.

+2  A: 

You sure can, done it a few times myself. Here is a link to show you how

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

Enjoy

Kevin Ross
As a follow up how can I change the icon that sits directly below the Excel application icon? I want to change the workbook icon as well. Any ideas? Thanks
xiaodai