Forum Discussion
Setting up a common subroutine(s) module/reference in Excel VBA
I need to have a common set of subroutines that can be used in .xlsm files while assuring subroutine consistency from one target file to another. I have done this successfully just very recently. ...
I'd either save the code in your personal macro workbook PERSONAL.XLSB, or in a workbook that you save as an Excel Add-in (*.xlam). If you choose the latter, activate the add-in in File > Options > Add-ins.