Main Subprocedure

Marcos Rodríguez wrote:

 

I'm running it from the normal macro toolbox

Why not set a macro button and set your required sub in that. This saves timing in browsing the macro and also run the correct sub

Marcos Rodríguez wrote:

 

Hi Deepak,

 

I'm running it from the normal macro toolbox, I think I've the solution. When I save the macro, before close it, the 'Main' Subprocedure has to be selected.

 

you can try it, the macro is attach to first question.

 

Regards.

A robust method (IMHO) is to make your subs have arguments.  You don't have to actually use them, and you can even make them optional.  The macro will not start with any sub that takes an argument (optional or not)

sub main()

     'do some stuff

     Call SomeOtherSubThatDoesntNeedArguments

     'OK now do more stuff

end sub

sub SomeOtherSubThatDoesntNeedArguments(Optional DummyArgumentAnyway as Boolean)

     'this sub's code

end sub