Why my workbooks stop cycling my Macro's ??

Guys,

I attach my workbooks to this post.

The workbook cycles through the workbook on certain times and if it is sunday it also switch the workbook.

First question is why my macro "Open_workbook" stops after one cycle to another workbook ?? If the macro cycled my workbook it stops i want it to continue all the time.

What i discovered that if a workbook closes and the other workbook is opened that my macro from my first workbook is stil in the macro list.

Second question is can somebody have a look at my workbook and look at the code and can make it easier load and work with less scripts ?

Thank you for you time and helping me out.

Regards Black7.