View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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