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!
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!