Changing the default “macros in all workbooks”

**aca** · 08-01-2006, 05:26 AM

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** · 08-01-2006, 06:21 AM

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.