How to group or organize dozens of macros?
 

What's the best way to organize macros in Excel? Can vba
macro procedures be easily moved from one module to
another? Reason for the question is that I've
accummulated several dozen macros, and need to group them
for easy management.

Thanks for your help!
Randy

How to group or organize dozens of macros?
 

Randy wrote:
What's the best way to organize macros in Excel?

I group macros with related functions into a module.
(e.g. all to do with charting in modCharting)
just so that I can more easily guess where to look.


Can vba
macro procedures be easily moved from one module to
another?

Yes. Just cut and paste.

You have to be careful if there are any module-level variables that are
used, to ensure that the procedures that use them can still "see" them
after the move.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup