Working with two monitors

Working with two monitors is realy great. There are keyboard shortcuts in Windows 7 that make the work with them much easier and faster (try for example WIN+arrows or WIN+SHIFT+left or right arrow). But if we want to use this tools in Excel, we have to work with multiple instances. However, in this case we lose advantages of the single instance (like copy + paste values etc.). Of course we can expand the application window manually through both monitors, click the some button for arrangement and adjust the windows of workbooks, but again manually. I was suprised I found a few tips how to do it by this way, but nothing for automatic arrangement. So I have decided to create this tool by myself.

I created Add-In which can be used for Excel 2010 and earlier. Excel 2013 uses a technology SDI (Single Document Interface), so we can enjoy the shortcuts.

---

Short demonstration of what the Add-In does:

Add-In can be translated to another languages:

---

You can download the Add-In from here: ArrangeWindowsOneInstance.zip
Warning: To place this file anywhere on the Internet without the author's permission is not allowed!

Package contents:

• ArrangeWindowsOneInstance.xlam - with the Ribbon (for Excel 2007, 2010)
• ArrangeWindowsOneInstanceNoRibbon.xla - without the Ribbon (for Excel 2003 a earlier)
• Czech.xls - file is used to translate the buttons to the Czech language (anyone can to create another translation). The procedure of the translation is described in the worksheet named HowTo

If you don't know, how to install the Add-In, you can find it in the application help or on the Internet.

---

Tested configurations:

• Windows 7 64bit + Microsoft Excel 2007 32bit
• Windows 7 32bit + Microsoft Excel 2007 32bit
• Windows XP 32bit + Microsoft Excel 2003 32bit

Known bugs or issues:

• Sometimes a window asking password of any currently opened project pops up during closing the application. This can repeat several times after click on the Cancel button. I don't know the reason for this behavior for now. The solution is to hold the Escape key for a moment (until it is no longer displayed)
  
  
  
  
  
• ActiveX elements must be allowed. If still there is an error (Run-time error 1004: Unable to get Object Property of OLEObject class), try this to fix it.

Tweet