Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing in separate windows
I have to work on multiple excel sheets at a time. I have checked the Windows
in Taskbar checkbox under tools - options. But when I restart the computer this is again getting unchecked. Also, all the workbooks are getting minimised if I minimise one workbook. How should I tackle this problem ? I am unable to do repair also as I am on shared network and I dont have access to utilities to be installed drive. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing in separate windows
This is a setting that's kept in the windows registry. For some reason, yours
isn't being kept. I'd talk to your IT folks to try to find the reason. Different versions of windows have more security about letting users write to the registry (WinXP, IIRC is one). Until you find the source of the problem, maybe you can just create a macro that changes that setting. Put the workbook with the macro in your XLStart folder and xl will open it each time you open excel. Option Explicit Sub auto_open() Application.ShowWindowsInTaskbar = True ThisWorkbook.Close savechanges:=False 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 ===== I have no idea why the other problem occurs. But you may want to post back with the version of excel and the version of windows that you're running. Maybe someone will know the problem. ===== By the way, do you use xl2k and shared workbooks? If you do, then there is a bug that will turn the windows in taskbar off when you open a workbook that's shared. Radha wrote: I have to work on multiple excel sheets at a time. I have checked the Windows in Taskbar checkbox under tools - options. But when I restart the computer this is again getting unchecked. Also, all the workbooks are getting minimised if I minimise one workbook. How should I tackle this problem ? I am unable to do repair also as I am on shared network and I dont have access to utilities to be installed drive. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing in separate windows | Excel Discussion (Misc queries) | |||
viewing files in separate windows | Excel Discussion (Misc queries) | |||
how do I get separate workbooks in separate windows | Excel Discussion (Misc queries) | |||
Open Separate Excel Files in Separate Windows | Excel Discussion (Misc queries) | |||
Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) |