Re: Opening Excel file in new window

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the feedback PapaDos. I was a bit unclear on what you were
talking about modifying. I will go back an try what you were talking about
now.


"PapaDos" <PapaDos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E1691969-E9C7-4E8E-A9A9-7200BBD3B85D@xxxxxxxxxxxxxxxx
I was not thinking about modifying the "New" action but creating another
action (like "Open in a new instance of Excel").
I would not recommend modifying standard actions like you did.
The "New" action is not used much by most Excel's users but it is useful
in
its own way, once in a while...

About the personal.xls problem, depending on how and what you are using
this
file for, saving it as an XLA would avoid the warning. But it makes
calling
its macros from VBA a bit more difficult...

--
Regards,
Luc.

"Festina Lente"


"Mark Ivey" wrote:

I think that is just one of the bugs that you have to accept if you need
to use a feature like this.


"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23BvaffyDHHA.3596@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for that Mark (and Luc for first drawing attention).
That works and does allow second Workbook to go to second screen, but I
keep getting the message that Personal.xls is locked for editing, Open
Read only, Notify Cancel. Does anybody know any registry change that can
by-pass this and just open Read Only?

--
Regards

Roger Govier


"Mark Ivey" <wmivey6311@xxxxxxxxxxx> wrote in message
news:evD9xkxDHHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
Here is a weblink with instructions explaining what PapaDos was
talking about:

http://www.graceba.net/~wmivey/New%20Instance%20of%20MS%20Excel.xls

If this link doesn't work, try the one below:

http://www.graceba.net/~wmivey/ then select the file labeled "New
Instance of MS Excel.xls"
"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uB7H7SxDHHA.1748@xxxxxxxxxxxxxxxxxxxxxxx
Hi Mark

I have just realised that I have been talking absolute rubbish (not
unusual<g>)

I drag the VBE window across to the second monitor, not 2 different
Excel files, so I can view code on one screen and what is happening on
the other screen. Opening another workbook does open on the same monitor
as the first workbook, and if I drag that file to the second monitor then
switch to the second workbook, that has moved as well.

I'm sorry to have caused the confusion.

I looked at Luc's response about changing the setting, but I
couldn't manage to get it to work.
What did you do?

--
Regards

Roger Govier


"Mark Ivey" <wmivey6311@xxxxxxxxxxx> wrote in message
news:Oq7EGFxDHHA.2080@xxxxxxxxxxxxxxxxxxxxxxx
Roger,

Do you have to adjust Excel to stretch across both monitors and
then size one open workbook to fit on the left side and another to fit on
the right side? This is what I believe you are saying. I would actually
like the convenience of having a new instance of Excel opened. This gives
some detachment between what I have open (from my left monitor to my
right), and allows for easy closing without the worry of loosing what I
am doing on one or the other side. PapaDos has the advice I was looking
for, but I was afraid it would alter how I opened EVERY Excel file (which
I found not to be the case). It allows for the user to right click an
Excel file and select New if they want a new instance of MS Excel loaded
when the file is opened.
"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:%23oR9hntDHHA.2328@xxxxxxxxxxxxxxxxxxxxxxx
Hi Mark

I am running XL2003. To show a file on my second monitor, all I
do is click the sizing button to the left of the closing "x" then whilst
holding the left mouse button down on the title bar, drag the file to the
left (in my case) and it appears on the second screen.

Only 1 instance of Excel is loaded but I can quite happily view
2 different files at the same time.

--
Regards

Roger Govier


"Mark Ivey" <wmivey6311@xxxxxxxxxxx> wrote in message
news:OUmrjwpDHHA.4312@xxxxxxxxxxxxxxxxxxxxxxx
If I have two monitors and would like to open more than one
instance of Excel so I can display one workbook on one screen and another
on the other screen, how would I go about it?

I am using MS Excel 2003, and I have heard there are some
issues with this feature.

All I have found so far on this topic would alter ANY xls
file to open in a new window (basically a system registry change), but I
would like to pick and choose when this occurs. I found one website that
said you could use your control key while opening a file to get it into a
new window, but that does not work on my PC for some reason.

Any ideas?

Thanks in advance..


.

Relevant Pages

  • Re: Opening Excel file in new window
    ... Just fixed it and updated the website info. Check it out again to see what ... That works and does allow second Workbook to go to second screen, ... I drag the VBE window across to the second monitor, ... Excel files, so I can view code on one screen and what is happening on ...
    (microsoft.public.excel)
  • Re: How to get two instances of Excel
    ... You can have a second instance of Excel. ... Once it's started, un-maximize it, and move it to your second monitor, then ... inner windows, each containing a workbook). ...
    (microsoft.public.excel.misc)
  • RE: Views on two different size monitors
    ... Found that when the CFO opens the workbook on his big monitor with Excel ... When the CFO opens our Finacials Workbook, makes changes and Saves, all ok. ...
    (microsoft.public.excel)
  • Re: How to get two instances of Excel
    ... but don't see why you need two instances of Excel. ... Two views of same workbook: add 1 workbook, Window, New Window, Window, ... The only downside is that you have your toolbars on the left monitor. ...
    (microsoft.public.excel.misc)
  • Re: ColorIndex vs Color?
    ... Compatibility mode means Excel won't try to put a value into cell ... Excel 2007 recognizes Excel 2003's palette, ... was assigned a customized palette in 2003, ... The source workbook just contains formatting information ... ...
    (microsoft.public.excel.programming)