Changing the default “macros in all workbooks”

[aca]

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.

 

[raypayette]

It seems to me that your code needs to be edited.
The macros' names should be unique.
The sheets and the workbooks should have unique names.
The code should refer to specifiv sheets.
You can use ThisWorkbook.Name in code

 

[aca]

Yes, I see now that my error lies there.
Thank you so much, ray
ACA