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?
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…