Calling Procedures by running a single macro in Excel
Posted on 2012-03-23
I would like my staff to be able to run a single macro (Analysis_Main) which executes a series of procedures. I only want the MainMacro to be visible in the macro window.
Here's the main sub:
Public Sub Analysis_Main()
Here's the error that I get. "Compile error: Sub or Function not defined." because Excel needs the Private subs in the same module, I guess. If I make them "Public" then they run but display in the macro window.
Should I make the subs "Public" or "Private" and where should I put them in relation to the various modules? Is there another setting that I'm missing here to accomplish what I want to do?
Thanks for your help.