@Joske920, @scottiex: Thanks both. I'll explore those suggestions at a later date but meanwhile I've changed my approach, at least for my current project.

One workbook, WalkIndex.xlsm, will always be open. So I'm going to keep all macros that operate on that and on associated workbooks in that main workbook. I'll use Personal.xlsb for macros that are used more widely.