Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only show currently active file icon
Using Office 2007 and Win XP;
When multiple XL files are open, each open XL file appears as a separate icon on the "Start" menu bar in Windows. Is there a way to hide those icons or only show the currently active file? If so, I would need to do this in VBA on the fly with the ability to switch back and preferably without resorting to APIs. If this is possible, could someone perhaps post example code on how to do this? Thanks much for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only show currently active file icon
Excel has two settings - One taskbar icon for Excel or one for each visible
window. There is no option for just the active workbook window. To code the switch between the two settings, record a macro as you switch manually using Excel Options, Advanced, Display section. -- Jim "XP" wrote in message ... | Using Office 2007 and Win XP; | | When multiple XL files are open, each open XL file appears as a separate | icon on the "Start" menu bar in Windows. | | Is there a way to hide those icons or only show the currently active file? | | If so, I would need to do this in VBA on the fly with the ability to switch | back and preferably without resorting to APIs. | | If this is possible, could someone perhaps post example code on how to do | this? | | Thanks much for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Show Desktop' taskbar icon | Excel Discussion (Misc queries) | |||
Show drop down icon | Excel Discussion (Misc queries) | |||
show icon caption bar in userform | Excel Programming | |||
What properties show on icon mouse-over? | Excel Programming | |||
Changing Excel Icon in the Active Window | Excel Programming |