Synchronize multiple worksheet windows

Hi. I have an Excel 2010 workbook that contains several worksheets, all based on the same template (only the data in the sheets is different). For simplicity, let's say that there are 5 worksheets in the workbook.

I have VBA code that creates 5 new windows, arranges them side-by-side, selects worksheet 1 in window 1, worksheet 2 in window 2, etc., and for each, sets them to a common scroll column and row.

I need now to make it so that all 5 worksheets are synchronized to scroll vertically. I've tried multiple ways using "ActiveWorkbook.Windows.arrange ActiveWorkbook:=True, SyncVertical:=True" but the best I've ever achieved is getting two of the 5 windows to sync.

Is there a way in VBA to get all 5 to scroll-sync vertically?

Thanks!

Hey

You have obviously the macro I need. I have two windows opened and wish to scroll both syncroniously in vertical orientation.. Can you give me a tip?

Eli Nielsen, DK

Hello elinielsen, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.