List of last running macros

Hi,
I have 50 macros in the Module1.
Every night I run these 50 macros one by one.
But, I have to be careful when running these 50 macros without skipping.
So, I need to see a list which macros I runned before.

So far, I found this way to follow which macros I runned before.

Please Login or Register  to view this content.

But, I believe that better way exist.
Thanks in advance.

why dont you get a macro to run the macros in sequence?

Please Login or Register  to view this content.

Each macro needs to set the error flag if it has an error

Mehmetcik kardeşim,
Anlayamadım ben biraz açıklar mısın ?

lets look at your first Macro.

lets say that it is

Please Login or Register  to view this content.

This is a simple macro that will set the public variable to 0 and change it to 1 if there is an error

so going back to your scheduling macro

Please Login or Register  to view this content.

Ok the following is my ""Error Control" subroutine
it simply looks at the error flag and displays a message.

I havn't used the macro number for anything because I realised that the error flag could tell me the macro number.
However if our macros have names and not numbers then

Please Login or Register  to view this content.

would give you access to the calling macro name for your error message.

Please Login or Register  to view this content.

Sorry, your explanations are very complicated. I dont understand what you mean...

Ahh

ok.

you can use a master macro to call each of your macros as sub macros.

The problem is that if there is an error the rest of the macros will keep running unless to take action to stop that.

Lets start slowly.

if you create a scheduling macro, you can get it to call macros one to 50 in order.

try building that.

Something like

Please Login or Register  to view this content.

The above code will cause macros 1 to 4 to run in order

Dear mehmetcik,
I run these 50 macros one by one because I need to see what happened after every macro run.
That means I dont want to run all of macros once.
Similar thing could be done connecting every macros with "call" code.

So, your advice is not suitable with my question

Dear martindwilson,
Your advice is to create a text file to follow every macros.
It is similar thing to create an userform to follow every macros.
But thanks for the answer.

You can pause after each macro by displaying a modeless userform that simply says click to run next macro.

Dear Mehmetçik,
How can I pause each macros in the exact time ?

Hi mehmetcik,
Thanks for the file.
But your macro has an error.
You can find error picture enclosed.

Hi mehmetcik,
Now this works great. Thank you...

Lets go second step...
How can I see every runned macros as a list in the same UserForm ?
I mean I want to see every runned macros as a list not only the last macro...

Solved.
http://www.excelforum.com/excel-prog...via-macro.html