Forum Discussion
Multiple Excel Macros For Different Functions
Morning all, Hoping someone can guide me. I have several different functions that i track for the team reporting to me. All are tracked in some form of excel workbook, which i copy for each new...
The cause of the problem is that the macros have the same name as the modules they're in.
I changed the names of the modules:
The macros then remain visible:
Remarks:
- You renamed the workbook module ThisWorkbook to Copy_Out. That is not a good idea; ThisWorkbook has a special meaning, so renaming it is confusing.
- You stored a standard macro Copy_Out in the workbook module. Although this is allowed, it is not a good idea either: the workbook module is intended for workbook-level event procedures such as Workbook_Open. Standard macros belong in standard modules - the kind you create by selecting Insert > Module.
can't thank you enough, i clearly skipped some of the detail in my tutorials on how to insert and name them. Truly appreciate your help, Hans!