Sub vs Public Sub

[stuck]

My brain is fogged today, I should (and probably do) know this already...

If a Sub is not explicitly named as either Private or Public, it defaults to Public, right? i.e.:

Code: Select all

Sub myMacro ()

is the same as:

Code: Select all

Public Sub myMacro()

Thanks you for indulging my mental block.

Ken

[Leif]

I believe this is correct. See Sub statement (VBA) | Microsoft Docs:

If not explicitly specified by using Public, Private, or Friend, Sub procedures are public by default.

[HansV]

What Leif says. A sub or function is public by default, while a variable or constant is private by default.

[stuck]

Thank you Leif, that was the link I should have been able to find for myself.

Thank you too Hans for confirming how it's the other way round for variables.

Ken

[HansV]

For your viewing pleasure: A matter of scope: visibility of code elements