Combine subs to run and appear as one in macro list

Add

Option Private Module

to the top of the module with these subs, and make them all Public.

Bob and mike (Bob first, mike below)


Okay here's my "Combine_Reports" sub as is

Please Login or Register  to view this content.

Then, I added

Option Private Module

and it looks like this

Please Login or Register  to view this content.

But once I do that, I go into Excel, hit the macro button, and the "Combine_Report" sub is no longer visible.

Note that my module names are named like this

Module_Report_Step_01
Module_Report_Step_02

etc..

mike,

I'm losing you on this part

Please Login or Register  to view this content.

Sorry to be such a newbie!

thanks,

duugg

I said ...

Add

Option Private Module

to the top of the module with these subs

In other words, before any subs.

Okay,

I was doing two things wrong.

I was adding

Please Login or Register  to view this content.

to the "Combine Sub", but it was below the "Combine Sub"

Then, I was adding it above the "Combine Sub"

Then, I thought I was supposed to add the "ADD" to it. So I tried this

Please Login or Register  to view this content.

Then I took Add/Option Private Module away from the combine sub and added it instead to each sub I was calling, like this...

Please Login or Register  to view this content.

and that didn't work.


What finally worked was this...

Please Login or Register  to view this content.

above each CALLED sub, without the ADD part.


So, in short the answer for newbies like me would be this.

Please Login or Register  to view this content.

Nothing is actually done at all to the Sub "Combine_Reports"
i.e. the one that calls all the reports

I'm glad to finally get this one resolved, thanks to all

Sometimes we says things that are clear to us but we forget how others may not have the intrinsic understanding that we have and so we are not necessarily as clar as we might be.

Glad you got it sorted.

Hey guys thanks for that and all your help again.

hey mike, when you put "Optional Dummy as Boolean" I thought I was supposed to replace it with something else, duh to me for that

I didn't think that words like "dummy' are actually vba code. Who wooda thunk? lol

anyways, thanks again