VBA triggers this event procedure every time you make a change in the sheet. That makes it a bit risky to use in a very busy worksheet—it can slow things down a bit. In this case, you won’t ...

Double-click the name to run the macro. A new hyperlink containing the text you specified appears in the selected cell. Move your mouse over the link to view the screen tip text.

In that case, VBA skips this step and continues with the next workbook. The code must skip the Personal.xlsb workbook because if it closes, it also stops running, perhaps leaving workbooks open.

You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.