Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing in separate windows Starblazer Excel Discussion (Misc queries) 6 September 23rd 08 11:22 PM
viewing files in separate windows CKE Excel Discussion (Misc queries) 1 January 18th 07 06:19 PM
how do I get separate workbooks in separate windows John Collins Excel Discussion (Misc queries) 3 October 28th 06 12:07 AM
Open Separate Excel Files in Separate Windows JTWood Excel Discussion (Misc queries) 3 May 7th 06 10:18 PM
Open Excel files in separate sessions, not just separate windows? Bob at Dexia Design Excel Discussion (Misc queries) 1 October 18th 05 05:46 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"