Can software automatically import and export VB modules in Excel? I want to circulate some spreadsheets which, upon opening, would automatically import the latest versions of my team's VB modules from a share drive. It would be a way of imposing source control on Excel macros.

I believe so. Basically you would put a macro in the spreadsheets you are distributing that goes and looks for the modules when opened and another macro that then disassociates them when closed. I don't recall the exact commands. I think there is an example in Help.

Thanks, Grok. But I don't think there is a natural way for VB to import/export VB modules: I already looked in Help. How about saving an .xla file? Would that solve my problem?

No, not import/export. Macros can be run from any available workbook, so have your controlled macros in a 'macroworkbook' on the shared drive and have the distributed spreadsheets call the macros from there. I think I used to do it using a custom toolbar with buttons for each macro which were assigned after displaying the toolbar and unassigned when closing the workbook. The unassigning is important, or the old macro will be called.