Pause Between Two Macro Sub Routines

[rafal1122]

Why don't you just call it in separate routines? If you really want to pause and look at the sheet, then shouldn't it just STOP instead of PAUSE

Ok, I will explain it again.

There is a macro which is called CallAll() where I call 10 other macros.

I have also implemented 'traffic lights' alerts to notify the end user when the macro runs, it changes from red to green.

What I was hoping to achieve is that when the end user runs the CallAll macro, the traffic lights (which I positioned against the button for each macro) will be changing from red to green, one by one, to make it looks nice. Unfortunately, when I imlpement any of the online solutions, all lights switch from red to green at once.

How do I make them to switch one by one?

Sub CallAll()

Call Macro1
traffic light1 goes from red to green
once sec delay
Call Macro 2
traffic light2 goes from red to green
once sec delay
..........

Change of the color of traffic ligths is implemented in each individual macro.