How to call a procedure from a different module, witihin "ThisWorkbook"

OK - I thought I understood this as I am doing it in other locations within my code.

While being in one module named "ModReportGenerator", I call to run other various procedures from other modules by using the naming convention of "modulename.procedurename" and this seems to work just fine.

But if I try to do this same thing within the"ThisWorkbook" sheet, this naming convention doesnt work and I am not able to call up a procedure.

My goal is to run the procedure named CLEAR that is located on module "ModInvoiceTabel" and run this code on "ThisWorkbook"

I tried:

Please Login or Register  to view this content.

and this doesnt work.

If the routine is declared public, it should work the same when called from ThisWorkbook as it does from anywhere. The phrase "doesn't work" is not particularly helpful though.

You said you were trying to run a sub in a normal module, so it is whether that called sub is public or private that matters, not whether the calling sub is.

Yes. The whole point of making it Private is so that it cannot be called from other modules.

You can leave the routine private and use

Please Login or Register  to view this content.