Multiple Document Windows

[jerry]

I'm a new user to Excel 2000. Unlike Excel 97, 2000 generates a new window every time a new document is open. Is there a macro, as I discovered for Word, which will keep all the open documents in a single window in Excel 2000?

 

[Chip Pearson]

Jerry,

Go to the Tools menu, choose Options, then the View tab. There,
uncheck the "Windows in taskbar" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I'm a new user to Excel 2000. Unlike Excel 97, 2000 generates a

new window every time a new document is open. Is there a macro,
as I discovered for Word, which will keep all the open documents
in a single window in Excel 2000?

 

[Dave Peterson]

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.