Restart macro when "another" workbook is opened

Please Login or Register  to view this content.

I tried adding " Call SetTime" after the Next WB in the second last line of code above. This does reset the timer but this time the pop up message does not automatically disappear and requires the user to click on the box to close the file which defeats the purpose

Could I "close and reopen" the menu workbook that contains the above code, and what would that involve

Ta Nigel

Sorted

When other workbooks are automatically closed the workbook that is the main menu is closed and reopened and "SetTime" called. This was the workaround for after the first "close workbooks", as the SetTime did not automatically restart, and clicking a macro button on the menu did not constitute a "SheetSelectionChange". If after the first close a workbook was opened from a macro button, there was no more timed "closed if inactive".

This way it continues in a loop until the "menu" workbook is closed.

In Workbook

Please Login or Register  to view this content.

In module

Please Login or Register  to view this content.

A counter was added to cell j6 to make sure workbook was opening and closing and can be hidden to monitor how many times the macro was invoked in use

Ta Nigel