Is it possible to make a macro have global scope?I've developed a macro for a specific use and now want to createseveral spinoffs.I'd like to be able to have changes to the global macro propagateacross all the child files using the macro.Is this possible?
Not sure if I am understanding the question correctly, but I thinkwhat you want to look at is creating an add-in -- basically, a VBAproject that can be easily turned on/off with all EXCEL workbooks viathe > Tools > Add-Ins menu option.
Yeah, it is possible. To perform the same, you should write this macro in"Personal.xls" workbook.