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...
It'd be easier to store the macros in the workbooks themselves.
When you copy one of the existing workbooks for a new month, you'll copy the macros with it, so the same macros will be available in the new copy.
Ok, thanks Hans! That's what I *thought* i did my first, time around with these macros, but since i'm a relative newb to this stuff, i likely screwed it up. I'll have to dig around a bit and see why some of the books have the macros and others don't.