Procedures/Macros in the list of Macros
 

Hi all,
I need a help. I would like to use a following hierarchy of procedures:

Billing - this one should ask a user to input the name of a country
after that it should go to procedures different for every country
BillingFR
BillingDE
BillingIT
etc.

I need that in the list of macros (in the personal.xls) I can see only the
Sub Billing() and not all other procedures like BillingFR (), BillingDE() etc.

Thanks for any advice.

Drahos

Procedures/Macros in the list of Macros
 

Declare your sub_procedures as Private sub BillingFR()

HTH
--
AP

"Drahos" a écrit dans le message de news:
...
Hi all,
I need a help. I would like to use a following hierarchy of procedures:

Billing - this one should ask a user to input the name of a country
after that it should go to procedures different for every country
BillingFR
BillingDE
BillingIT
etc.

I need that in the list of macros (in the personal.xls) I can see only the
Sub Billing() and not all other procedures like BillingFR (), BillingDE()
etc.

Thanks for any advice.

Drahos

Procedures/Macros in the list of Macros
 

Hi Ardus Petus,
thanks a lot for advice. It works.
Best Regards
Drahos.

"Ardus Petus" wrote:

Declare your sub_procedures as Private sub BillingFR()

HTH
--
AP

"Drahos" a écrit dans le message de news:
...
Hi all,
I need a help. I would like to use a following hierarchy of procedures:

Billing - this one should ask a user to input the name of a country
after that it should go to procedures different for every country
BillingFR
BillingDE
BillingIT
etc.

I need that in the list of macros (in the personal.xls) I can see only the
Sub Billing() and not all other procedures like BillingFR (), BillingDE()
etc.

Thanks for any advice.

Drahos