try going to tools/options/general and unclick the zoom on roll of intellimouse
hope this helps.
Now about your first questine I don't think its posible, I think it has to open another window. What is the reson to have it open in the same window, maybe I can help with an alternative.
Let me know
steve w
1) When I have an Excel workbook open and go to open another workbook, they open in seperate windows. How do I get them to open just using one window?
Thanks for the tip on the mouse..it worked.
Now, the other question. When I go to open a second worksheet, it's like I'm opening a second Excel program. It shows two spreadsheets on my Task Bar and if I go to close the second spreadsheet (using the top "X") it closes Excel altogether. Shouldn't Excel just open the spreadsheet without acting like it's opening another program?
I believe you're using windows 2000. If you click on Window in Excel, you will see that both sheets are open in the same copy of Excel. There is only one copy running, it's just that Windows 2000 displays it as two tasks on the task bar. When you click on the top "x", it closes Excel, only one copy open, so both worksheets close. Click on the lower "x" to close the active worksheet.
I'm using Windows98. And at work, I use Windows98 also. There, I can open several worksheets and I only see one icon on the Task Bar that represents Excel, no matter how many worksheets I have open.
If you are using excel2000 then there is an option
in Tools / Options / View = Windows in taskbar
Just deselect this to get more then one icon
for excel.
Ivan
Thanks, I figured this out at work yesterday. Even the IS department couldn't remember how to do this!