I require some VBA code so if the person executes the macro while the macro workbook is the active workbook then the macro moves to the next open workbook.

I thought something like the following:

Dim WB As Workbook
For Each WB in Workbooks
If WB Is ThisWorkbook Then Next WB