Hello,
I'd like to run macros from Personal.xlsb to avoid inserting them into individual workbooks and saving the workbooks as xlsm.
The only problem I have is with macros placed in ThisWorkbook object of xlsm files, triggered on SheetChange.
To make it simple, this is a sample macro, which just opens a messagebox:
How can I make it work from Personal.xlsb, so that the macro will be triggered by any opened/active workbook (xlsx) on its "SheetChange"?![]()
Please Login or Register to view this content.
Thanks for helping me.
Bookmarks