The code to call a macro in another workbook or the personal.xlsb is fairly easy, for example
Application.Run ("Personal.xlsb!Bubble")
Have build a large library of universally running macros [project specific though], that process all sorts in the active project related workbooks. The crux I'm struggling with is: Some project workbooks have certain customizations [in name the same, but executing quite differently]. These are captured in the workbook specific macros. I'd like to call these from the general purpose macros in the personal.xlsb, but for the life of it, can't find anything on this, either because my search phrases are not precise enough, or it's simply a 'not-done' practice. Silly workaround has been to start a macro in the workbook to call the macros in personal.xlsb, but anytime some module is added to personal, have to go through all workbooks to adept the macros there too.
Any hint most welcome.
BTW, the names of the workbooks change all the time, so using ActiveWorkbook. to pass variables back and forth which procedures in personal can use.
Bookmarks