Breaking News: Grepper is joining You.com. Read the official announcement!

vba sub only available for modules

DevPedrada answered on February 20, 2024 Popularity 1/10 Helpfulness 1/10

answer vba sub only available for modules

vba sub only available for modules

Comment

Specify Option Private Module at the top of ModuleB; public members won't be (visibly) exposed to the user, but will be readily available from anywhere inside the VBA project.

Your Private+Application.Run hack is.. well, a hack. Don't do that - make/leave public members Public, and hide the module from the macros list with Option Private Module.

Popularity 1/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: vba

Link to this answer
Share Copy Link