We have a macro enabled workbook (ver. 2010) that many people use. A few of these people have macros in their Personal.xlsb workbook. We have a situation where the macro in the shared workbook is named the same as a macro in personal workbooks but does slightly different things.
To avoid running the wrong macro, I'd like to default the shared workbook to run macros from This Workbook instead of All Open Workbooks. I expect to place something in WorkBook_Open()
, but what?
Is there a way to change the default option for Macros in: All Open Workbooks
to This Workbook
?