Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
record dozens and singles in same cell and sum them? | Excel Discussion (Misc queries) | |||
Possible to organize all this?? | Charts and Charting in Excel | |||
how do I organize events | Excel Discussion (Misc queries) | |||
Working with dozens | Excel Discussion (Misc queries) | |||
Don't know how to organize info I have. | Excel Discussion (Misc queries) |