Changing the default “macros in all workbooks”

In Excel, when we open several workbooks containing macros, the default option is that the macros of them all are active; which sometimes causes a particular macro to act on the wrong file or workbook.
So I have to MANUALLY go to TOOLS>MACROS and, in the MACROS IN box below the list of macros, select the option THIS WORKBOOK instead of the default ALL WORKBOOKS.
Is there a way of having that default permanently so changed on my Excel, or of having it changed AUTOMATICALLY on opening the workbook?

Many thanks for any help or tip.
A. C.