Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Windows in Taskbar" setting is lost everytime I close XL
This is Excel 2000 running on XP Pro SP2.
I want my excel docs to each have their own taskbar button instead sharing one single one. If I go to Tools, Options, View tab and check the checkbox for "Windows in Taskbar" and click OK, it changes the behavior to exactly how I want. However, as soon as I close Excel, this setting is lost. If I close Excel, immediately reopen it, and go back to that checkbox, it's unchecked again. Why on earth won't it stick longer than one Excel session? Any ideas would be greatly appreciated. TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Windows in Taskbar" setting is lost everytime I close XL
Do you work with shared workbooks?
Saved from a previous post: Is the workbook shared? (A bug in xl2k turns it off for shared workbooks.) You could create a new workbook saved into XLStart (or put this into your personal.xls workbook) and it'll toggle that option each time you open a workbook. In the ThisWorkbook module: Option Explicit Public WithEvents xlApp As Excel.Application Private Sub Workbook_Open() Set xlApp = Application End Sub Private Sub Workbook_Close() Set xlApp = Nothing End Sub Private Sub xlApp_NewWorkbook(ByVal Wb As Workbook) Application.ShowWindowsInTaskbar = True End Sub Private Sub xlApp_WorkbookOpen(ByVal Wb As Workbook) Application.ShowWindowsInTaskbar = True End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm =================== If none of your workbooks are shared, then it sounds like you don't have permission to save that setting in the windows registry. yerk55 wrote: This is Excel 2000 running on XP Pro SP2. I want my excel docs to each have their own taskbar button instead sharing one single one. If I go to Tools, Options, View tab and check the checkbox for "Windows in Taskbar" and click OK, it changes the behavior to exactly how I want. However, as soon as I close Excel, this setting is lost. If I close Excel, immediately reopen it, and go back to that checkbox, it's unchecked again. Why on earth won't it stick longer than one Excel session? Any ideas would be greatly appreciated. TIA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel close everytime I receive an email with lotus notes 6.5.5 | Excel Discussion (Misc queries) | |||
How to determine the maximum lost? | Excel Discussion (Misc queries) | |||
excel 'lost my title bar with min. restore down, close buttons' | Excel Discussion (Misc queries) |