Forum Discussion
Multiple Excel Macros For Different Functions
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.
Hans - can you tell me what i'm missing? I've had this on the back burner for other priorities but looked at one example this morning. If in the VBA editor window opened only on a single excel workbook where i made (and thought i saved) three macros specific to that workbooks function, i see all the macros in a module folder under that workbooks title...
And yet when i go to add buttons/icons for these to the ribbon or tool bar, i see them ONLY when i select "Add To All Documents" - shot one below, and they disappear when I select "For Downtime Rollup" only. My goal is to make them only available in Downtime Rollup. Did i save them wrong somehow?
Thanks
Joe
That is strange. could you attach a copy of the workbook, or make it available through OneDrive, Google Drive, Dropbox or similar?
Yay! glad it also looks weird to someone else - who knows more of this stuff. It's been confusing the hell out of me. I've attached, and hope it's helpful. I'm sure the macros will be problematic if you need to test since they are all programmed to refer to specific share drive locations the sheet won't be able to access from this forum location...
I figure worst case, perhaps i can export the macros, save, and then reimport "to this workbook" only, and save a new version?
Thanks!
Joe
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.
