4
In my work all coding can be done in VBA only, hence, all of our tools (dbase queries, data processing, cash overviews, etc) are written as XLSM files.
At the moment, I have approximately 20 different tools and once I open up some of them, it takes some time to search for the specific tool in the taskbar as they all show up as (stacked) Excel icons. So my goal is to be able to assign different icons to different XLSM tools so that they appear as separate/different icons in the taskbar.
Is this possible? I'm on Windows 7 x64 with Office 2010.
EDIT:
I have theoretically figured a way: Make a copy of Excel.exe
to, say Excel_.exe
, change the icon of this Excel_.exe, thenlaunch one tool in this copy of the Excel binary. The first problem with this approach is that upon trying to launch Excel_.exe I get an error about a missing DLL file (MSVCR90.dll), which naturally does not occur with the original Excel.exe - does anybody have a clue why this happens?
1There may be an advanced way of doing this but OOB I believe there's no way to change the icon. However, if you're doing everything in Excel, could you create a master book with buttons pointed to each book, and give each book a button to go back to the master book? – CLockeWork – 2014-07-07T08:10:20.410
@CLockeWork: Thanks for a suggestion. I will give it a thorough thought! One thing I figured out, though, is that even if I managed to give the excel file a different icon based on the file's name, Windows does not decide whether to stack applications under one icon based on the file icon, but based on the app name - all the tools would still stack under one Excel icon in the taskbar, thus not solving my problem. – Daniel Bencik – 2014-07-07T11:18:06.997
This probably would help you. Try to set the Icon as soon the workbook is loaded using Workbook_Open. – jjk_charles – 2014-12-18T12:44:54.087
@jjk_charles: Hello, thanks a lot for the recommendation. However, this approach and its variants only changes the icon on the window, not in the taskbar. – Daniel Bencik – 2014-12-29T13:19:16.673
@Daniel Bencik did you try using a 32 pixel icon for ICON_BIG as mentioned in the answer? – jjk_charles – 2014-12-29T15:16:19.107
@jjk_charles: Unfortunately yes. – Daniel Bencik – 2014-12-30T08:11:34.363