Free Microsoft Excel 2013 Quick Reference

Two Monitors / Two Instances

I have two users using Vista and Excel 2007. They each have two monitors.

One machine opens multiple workbooks in multiple instances and can move them from one monitor to the other.

The other opens all workbooks in a single instance which must then be streched over both monitors and arrange the workbooks side by side.

How can I change the second one to behave like the first?

--
Carlos


Post your answer or comment

comments powered by Disqus
Yes, there is a way. Assuming you are using something like a Matrox Dualhead monitor setup (like me! Two monitors are really great, aren't they? I'd rather have 2 x 15" monitors than 1 x 20"!):

Start Excel
Make sure it is not in Full-Screen more - click the "Restore Down" button (top right hand corner of Excel window, the middle button) so Excel is in a smaller floating window.
Now drag the top left corner of Excel to the top left of your left monitor and the bottom right corner of Excel to the bottom right of your right monitor
You should now have Excel covering the whole of your two monitors
Open your spreadsheet and make sure it is not in Full-Screen more - click its "Restore Down" button (top right hand corner of sheet, the middle button)
Click the edges and drag - resize it to fill one monitor
Open whatever else you want, and click the edges and drag - resize it to fit the other monitor

My thanks to "Gib" for this one

I use two monitors on my desk. Some applications like MS Word allow me to put documents on each monitor.

Is there a way to force Excel to act in this manner? I would love to put the VBA Editor on one screen and the spreadsheet screen on another.

It's a great time saver and cuts down on the cofusion.

Any ideas?

I would like to have two separate instances of excel.

I do not want to tile them within a single instance. I want to arrange them
on the desktop.

I can do this in Word and used to be able to do it in Excel. Since Excel
2003 came on the market, I have not found the way to do this anymore. It has
changed or I lost the recipe. I suspect MS made the change.

I am using two monitors and have this question.

Is there any way to control a UserForm such that it will always pop up on
the screen of my choice?

For example, I want the UserForm to always opn on the right hand monitor but
it pops up on the left one, even though the Excel file is on the right hand
monitor.

Thanks
Al

Hi,

Does anyone have any VBA code that allows you to toggle between two different instances of MS Excel? The workbook names will be static, so there is no need to worry about what the workbook names will be. Any help would be greatly appreciated?? Thanks!

I need a BIG HELP!!!!Thanks In advance to who will help me!!!

I have two monitors and I want to visualize two excel windows opened in the two monitors.

The problem is that when I open one window I can minimize the window laterally but not from the top. It seems that is fix on the top and I cannot neither visualize the pointer cursor to minimize diagonally.

Sorry if I was not clear just ask if you need more deatails.

I have excel 2007!!

I am running Windows XP Pro

I have a two monitor installation arrangement configured to be independant
screens to which I can drag window to one or the other.

I can open two separate instances of Excel 2003 Via Start | Run | and
entering "excel" for each instance of excel I would want to compare.

I have googled to find out if this is the correct and only way to run two
instances of an application but the results are vague.

Question 1
Can anyone advise me how the method above works?

Question 2
What other methods can be used to achieve two instances of an application
running.

Excel appears to only support a single instance with multiple windows,
correct? I ask as I want to work with two instances on two monitors
(with different resolutions) and find this impossible. I can stretch
the one instance across both monitors, but this is clunky and means
part of one monitor is unused.

P.

My users (who are accountants) use dual monitors and would like to open a
different Excel file on each monitor for the purposes of reviewing changes
between the two. I know that one method of doing this is by opening Excel
twice with its shortcut, then highlighting one Excel window and opening an
Excel file, then highlighting the other window and opening the other Excel
file. Unfortunately, the software that my users use to organize the Excel
files does not allow this to be done; it always opens every Excel file in the
first Excel window no matter which instance is highlighted. We had a similar
problem with Adobe Acrobat, but there is a command line switch that forces
Acrobat to open a new instance for each file.
Is there a similar switch for Excel, or some other method of forcing Excel
to open a new instance of itself for each file? We are running Excel 2003 on
Windows XP. Thank you in advance for your replies.

When you have a graphics card to run multiple monitors, you can open different workbooks and disply them across a "streched" instance of Excel.

I have learned that whatever screen you save the book on last, will be the screen that it will appear on the next time you open it. Meaning if it is saved to screen two (which is not the Primary), you will not see it until you minimize Excel and strech it out to cover both screens.

My Problem:

I use four monitors and have saved a (actually a couple) book(s) from (I don't know which monitor). Now every time I try to open the book, I have 2 problems.

1. If it is the only book I am opening, Execl shows in the Tray but right clicking does not show the name of the book. If I try to reopen the book again, it tells me that it is already open. It will only show the name if I open another book.

2. Once the above is done, the only way to "show" the book is to right click > choose the book > Maximize. Of course, if I am streched to my four screens, I get the book streched that far also.

3. Once the book is open, I have tried to Minimize it, which only puts it down in the lower left hand corner as the Title bar waiting to be reactivated.

If other books had been saved to, say monitor two, and opened to a Full screen, if I click on the Minimize button, that book would be able to be dragged to whatever monitor I wanted.

This is not the case with these particluar books!!

I have tried everthing I can think of with no luck. Could really use some help on this. ( This is not only on my computer at work, but also at home with Two monitors)

Harry

I use two monitors for my laptop. If I launch two instances of Excel, I can
drag one instance to the other monitor and work in two spreadsheets maximized
at one time. My coworker's Excel, on the other hand, opens one instance of
Excel, and all spreadsheets open in the same instance, and are each listed in
the "Windows" menu. So the only way she can view both sheets at one time is
to spread Excel over the length of both monitors and then arrange the windows
side-by-side within the same instance. Looking at previous posts, I thought
the solution was Tools - Options - View - Windows in Taskbar. However, hers
is already checked, the same as mine. In fact, we can't find any settings
that look any different between her setup and mine. Any ideas?

TIA

I keep thinking microsoft is going to fix this some day, and
occassionly I look to see if someone has a solution that works. So
here I go. Does anyone know how to open two excel windows, one on each
monitor in a dual monitor setup? I know you can expand one window
across both monitors, but the technique is kludgy and has problems.
Thanks.

Using Excel 2003

Since setting up my desktop onto two monitors I find that I open more than one instance of Excel on a pretty regular basis. I've noticed that when I try to copy data from one instance of Excel to another that the Paste Special dialog box is not the box for pasting data within Excel but switches to the Paste Special dialog box for pasting from another app. Is it possible to change this so that I can stil "paste - special - values" and other useful "paste - special" combos like formatting etc.?

My apologies if this is answered elsewhere, I've searched and can't find the subject. I think I just don't know what to search for . . .

Thanks!

Does anyone know if it is possible to set-up Excel so when you have multiple instances open you can link a cell in a worksheet from another instance (other than typing the cell manually in the formula bar). I know I could just have one instance in two monitors but I find it a pain having to have one instance in two screens (I want the same set of tool bars in each monitor, and sizing is a pain). I have a feeling there is no way around it because of coding but I want have my cake and eat it to.

I have a work sheet which has a number of drop down validation cells with multiple selection option, these cells are in two different groups and need to have different seperators for each group... Group 1 has a seperator of "|" group 2 has a seperator of ";".

Originally, I had the two groups on different worksheets within the same file, however this is not pratical. I now need to merge the groups into the same worksheet.

here is the code for group 1


	VB:
	
 
 
Private Sub ComboBox1_Change() 
     
End Sub 
 
 ' Developed by Contextures Inc.
 ' www.contextures.com
Private Sub Worksheet_Change(ByVal Target As Range) 
    Dim rngDV As Range 
    Dim oldVal As String 
    Dim newVal As String 
    Dim lUsed As Long 
    If Target.Count > 1 Then Goto exitHandler 
     
    On Error Resume Next 
    Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) 
    On Error Goto exitHandler 
     
    If rngDV Is Nothing Then Goto exitHandler 
     
    If Intersect(Target, rngDV) Is Nothing Then 
         'do nothing
    Else 
        Application.EnableEvents = False 
        newVal = Target.Value 
        Application.Undo 
        oldVal = Target.Value 
        Target.Value = newVal 
        If Target.Column = 4 Then 
            If oldVal = "" Then 
                 'do nothing
            Else 
                If newVal = "" Then 
                     'do nothing
                Else 
                    lUsed = InStr(1, oldVal, newVal) 
                    If lUsed > 0 Then 
                        If Right(oldVal, Len(newVal)) = newVal Then 
                            Target.Value = Left(oldVal, Len(oldVal) - Len(newVal) - 2) 
                        Else 
                            Target.Value = Replace(oldVal, newVal & "|", "") 
                        End If 
                    Else 
                        Target.Value = oldVal _ 
                        & "|" & newVal 
                    End If 
                     
                End If 
            End If 
        End If 
    End If 
     
exitHandler: 
    Application.EnableEvents = True 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Here's the code for group 2


	VB:
	
 
Private Sub Worksheet_Change(ByVal Target As Range) 
    Dim rngDV As Range 
    Dim oldVal As String 
    Dim newVal As String 
    Dim lUsed As Long 
    If Target.Count > 1 Then Goto exitHandler 
     
    On Error Resume Next 
    Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) 
    On Error Goto exitHandler 
     
    If rngDV Is Nothing Then Goto exitHandler 
     
    If Intersect(Target, rngDV) Is Nothing Then 
         'do nothing
    Else 
        Application.EnableEvents = False 
        newVal = Target.Value 
        Application.Undo 
        oldVal = Target.Value 
        Target.Value = newVal 
        If Target.Column = 5 Or Target.Column = 6 Or Target.Column = 7 Or Target.Column = 8 Or Target.Column = 9 Or
Target.Column = 10 Then 
            If oldVal = "" Then 
                 'do nothing
            Else 
                If newVal = "" Then 
                     'do nothing
                Else 
                    lUsed = InStr(1, oldVal, newVal) 
                    If lUsed > 0 Then 
                        If Right(oldVal, Len(newVal)) = newVal Then 
                            Target.Value = Left(oldVal, Len(oldVal) - Len(newVal) - 2) 
                        Else 
                            Target.Value = Replace(oldVal, newVal & ";", "") 
                        End If 
                    Else 
                        Target.Value = oldVal _ 
                        & ";" & newVal 
                    End If 
                     
                End If 
            End If 
        End If 
    End If 
     
exitHandler: 
    Application.EnableEvents = True 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
In addition I have a small error within Group 1: If the user clicks on the option (when the cell already has the information contained) the selection is removed, however this is also deleting the last character of the selection preceeding the deleted entry which renders the cell useless can anyone show me where my code is making this happen.

Thank you

My desktop has 2 monitors. A question came up to me wanting to know if is it possible to have a different worksheet on different monitors.

Thank you!

Hey guys,

I'm doing lots of spreadsheet work and I'm trying to figure out how to work...faster.

I have two spreadsheets open in two seperate instances of Excel on two different screens. However, I noticed that when i copy data from one spreadsheet over to the next, I can't copy formulas. (Paste special gives the "paste as bitmap" option only).

Any way around this?

Thanks!

Hi

I am having an issue regarding the use of two instances of excel for purposes of a display. A quick synoposis of what I am doing. I use two seperate instances of excel, not workbooks, for this project. I do this so that I can run two different macros at the same time for data that is not linked in any way. Each macro is set to run at a specific time, with one repeating every 2.5 minutes, and one repeating every hour.

I have the times to run for each macro tied to a macro that sits in the instance it is to be used. For some reason, every time the hourly macro tries to run, it asks the message to enable macros (to which I hit enable) and then the message that the book is already open by another user (me), to which I hit cancel, in the instance that the 2.5 minute macro is running. When I do this, it doesn't open the excel sheet in the 2.5 min macro but runs it just fine in the proper instance. I can't be expected to click enable, then cancel every hour when the macro needs to run so I am looking for a solution. One idea I had was to make sure that the instance containing the hourly macro was selected prior to it being run, unfortunately I had no luck with getobject in selecting the right book. In all fairness I have no experience using that command. My other idea was to automatically enable and hit cancel on the next message but I have no idea how to do that.

I know this message is probably pretty confusing but I'll try and clarify any questions you have to help me. Thanks for any suggestions.

Hi all.

Done a quick search but not found anything here that answers this one.

I followed this tutorial
http://www.fontstuff.com/vba/vbatut07.htm
about creating a calendar control, mentioned in this thread
http://www.mrexcel.com/forum/showthread.php?t=333298
by VogII.
It was absolutely fantastic for someone as ignorant of VBA as I am - a real education.

I got the control working absolutely fine.
But it's caused a small problem elsewhere.
The control uses the file personal.xls, which did not exist on my machine before I created it today.
I also have Excel set up so that, on booting up, it opens up two separate instances of Excel, with one file in each.
It seems that each of the two instances of Excel tries to open its own instance of personal.xls, and gives me a read-only option for the second instance.

I can think of three possible solutions, but one isn't very attractive and I don't know how to do the other two, or if they are even possible.

Option 1 - change it so that I only have one file opening on bootup - I can do this, but I'd rather not.
Option 2 - make each of the auto-open files open within the same instance of Excel - I don't know how to do this.
Option 3 - keep 2 instances of Excel, but somehow make the second instance realise that personal.xls is already open, and therefore not try to open it again - I don't know how to do this.

Anyone have any ideas on how to do either Option 2 OR Option 3 ?

Thanks in advance !

Hi all

I'm trying to improve my application by using class modules for a more object-oriented approach...
So far, it went quite well, but I'm trying some more complicated stuff now, and there is some behaviour I don't understand. I hope someone can point out my mistakes...

I have a class module A, which has as private members (a.o.) two instances of class B objects. That all works fine. Then I added class module C, also with two private instances of class D objects.
In class C, I created a method that uses an instance of class A as a parameter. I found out that passing such an instance as parameter can be done only as Variant, and then re-setting it internally to the correct type.
So far so good, here's the code of the method:
Code:
 
'METHOD Compare Structured Boms
Public Sub Compare(UploadBoms As Variant)
    Set m_Uploads = UploadBoms
    Stop
    If m_Uploads.m_Bom1.LastLine > m_Uploads.m_Bom2.LastLine Then
        m_UploadsLastLine = m_Uploads.m_Bom1.LastLine
    Else
        m_UploadsLastLine = m_Uploads.m_Bom2.LastLine
    End If
End Sub
m_Uploads is the private member in class C that contains the passed instance UploadBoms of class A. The m_Bom1 and m_Bom2 are the private instances of class D.
If I comment out the If-Then-Else lines, this method works. At the stop, I can inspect the locals-window for the active variables/objects. The m_Uploads object exists and has all expected members. In the Immediate window I can enter for instance:
?m_Uploads.m_Bom1.LastLine
and it gives me the expected result.

But when I don't comment out the If-Then-Else lines, I get an error at the If-line, "Compile Error: Method or data member not found", with the m_Bom1 highlighted. In the locals window, I can see that the m_Uploads is not yet initialized...
This member however worked perfectly when I commented out the lines and inspected the locals-window???

What am I doing wrong here?

Thanks in advance for any help...

Hi all,

I have a Workbook that, upon opening, loads a Userform and then immediately sets the Application & VBE Visible property to False.

The userform intialize & Activate events contain code that sets the UserForm window Styles so that it can be minimized to the TaskBar .They also contain code that sends the WM_SETICON Window Message to the userform so that an Icon is displayed on the Form & TaskBar windows.

The idea behind all this preliminary Code is to make the Form work and look as a Standalone application.

I want to have this Form permanently loaded which I can do by saving the workbook in Windows StartUp folder.

So far so good.

Problem :

If the user Starts a new Excel instance by Opening the Excel application program directly , a new Excel instance is launched leaving the loaded Userform and its associated application instance separatly running in peace .

BUT, if the user starts Excel by clicking on a Workbook icon ( Say a WB icon on the Desktop ), then the already running instance of Excel becomes visible and opens the new workbook which ruins everything

How can I make sure that Excel ALWAYS opens a new instance if the UserForm is loaded ?

Regards.

I have two monitors. In most applications I can have separate pages
displayed on each monitor. Excell will not allow me to do that. Can anyone
tell me how to fix this problem?
--
Judy

Hi Friends,

I have one doubt in excel chart. Can i generate the excel
chart with out opening the excel instance?

I mean in my server system there is no ms office excel. We cannot
install it in server. because some license, security problem. I have to
create a excel chart dynamically. After user can download it from their
client system. So Can i generate the excel chart with out opening the
excel instance?

And excel instance has concurrent issue. At same time two more
instance is not running.

Pls give valuable solution.

Thanks
Ram kumar.

--
ramkumar_cpt
------------------------------------------------------------------------
ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
View this thread: http://www.excelforum.com/showthread...hreadid=517688

i use to be able to open two different excel spreadsheets and it would open
up excel application program twice...where i can toggle on the task bar
between two different excel programs...but now...it just opens up one excel
program and has both spreadsheets in one instance where i have to click on
window and then pick which spreadsheet to look at.

My question is: i want to be able to go back where the two spreadsheets
were in two different instances of the excel program where it would open one
spreadsheet up in excel and open the other spreadsheet up in another excel
instance where i can toggle between both apps or spreadsheets on the task bar?

Thanks

RoB


No luck finding an answer? You could always try Google.