Is it possible to create Excel VBA Code Library that several workbooks share? -

i have several workbooks have similar , reused vba code need update code , in 1 place instead of in 20 different workbooks possible?

if not there way copy macros 1 workbook others after change has been made?

yes, can reference other workbooks vba. might easiest put in addin though.

if using class modules, can set them either private or public not createable (something that). they'll need public, can around inability create them building simple helper functions in normal module nothing other create new instance of class , return it.