Cycle through active workbooks.

Lucy x

New Member
Joined
Oct 11, 2014
Messages
2
I'm relatively new to VBA so excuse my ignorance. I've been searching the net for the last hour for a solution to this with no luck.

I want a macro that activates the next open workbook. Just say i've got 10 open workbooks, it would be nice to have somthing similar to the Alt + Tab function for switching windows but for workbooks that are open in a single Excel window.

I've tried playing around with the auto indexing to activate a workbook but with my limited knowlege i'd have to assign workbooks 1 to 10 to seperate keystrokes.

Please Help!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,108,956
Messages
5,525,883
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top