Open workbooks in different windows

When i open several Excel Workbooks i like them to all be in seperate windows so i can have then on seperate screens and with seperate contols.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/automatically-hide-rows-in-excel-based-on-value/17036d97-a5c9-42a2-9f2d-f53d53510da7

answers.microsoft.com/en-us/office/forum/office_2010-excel/a...

I have to develop an excelsheet where a row is hidden automatically if the value in cell e is 1 and unhide the row automatically if the value in cell e is 2. And this has to work for all rows.

Visited148
https://social.technet.microsoft.com/Forums/office/en-US/ee76d08d-3306-406d-894c-16fd3cb824d9/each-workbook-in-separate-windows-excel-2010-windows-7?forum=excel

social.technet.microsoft.com/Forums/office/en-US/ee76d08d-33...

A useful thread but my favourite solution is:

  1. Find excel.exe
  2. Create shortcut to excel.exe on desktop
  3. Drag and drop excel files on shortcut
  4. Voila, multiple instance of excel.exe and all file remain visible...

    Visited133
http://www.mrexcel.com/forum/excel-questions/550371-hide-rows-based-formula-result.html

www.mrexcel.com/forum/excel-questions/550371-hide-rows-based...

I dont know much about VBA but can anyone help? I need a macro that will hide all rows where the formula result is zero as a result of the cost centre selected from a validation list?

Visited75
http://excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.html

excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.htm...

This tip contains a macro to hide rows that contain data you don't want to see. (Tips.Net)

 

Visited174
https://social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45-806f-9a42258bdb5f/how-to-open-two-excel-files-in-multiple-monitors-in-windows-7?forum=excel

social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45...

How to open two excel files in two excel windows using multiple monitors in Windows 7.
Currently it opens multiple files on top of each other on the same one monitor.

Visited117
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/i-want-to-open-2-excel-files-in-separate-windows/f7588d9a-3c41-466f-8f01-3b6ab9661ae3

answers.microsoft.com/en-us/office/forum/office_2010-excel/i...

I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window.

Visited211
http://stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a-row-or-column-in-excel-without-using-vba

stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a...

I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to kno ...

Visited106
http://stackoverflow.com/questions/20986436/hiding-rows-in-excel-based-on-words-in-a-cell

stackoverflow.com/questions/20986436/hiding-rows-in-excel-ba...

I am VERY new at VBA and have been searching for VBA code that can do what I want. I have tried several and attempted to adapt them however I just can't seem to get them right so thought I would try for some help!

Visited88