Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Rick,
Possibly use the Before_Close event of a workbook that will always be open - possibly your Personal macro workbook, to restore the setting. '=========== Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ShowWindowsInTaskbar = False End Sub '<<=========== This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. --- Regards. Norman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"minimize multiple excel workbooks on windows taskbar" | Excel Discussion (Misc queries) | |||
Excel "Windows in Taskbar" check box | Excel Discussion (Misc queries) | |||
"Windows in Taskbar" setting is lost everytime I close XL | Excel Discussion (Misc queries) | |||
"Show Windows in Taskbar" option from the ToolsOptionsView broke | Excel Discussion (Misc queries) | |||
"Programmatic Access to be Denied" displays when running macro on excel in XP | Excel Programming |