Changing the "Macros in" default setting

[aca]

To the attention of Ron Coderre, if possible:
Ron, you just helped me change the screen viewing zoom, by means of a macro the core instruction of which is “ActiveWindow.Zoom”:

Please Login or Register  to view this content.

I wonder if there is something similar for this other default setting: the “Mcros in:” field in the macro dialogue box.
In my Excel 2002, the default option in this field is “All workbooks open” and I would like to change it to “This workbook”. Is there any code equivalent to "If ActiveWindow.Macros In = All workbooks, then ActiveWindow.Macros In = This workbook..."?

Thank you for any new help.
ACA

[Paul]

Hi Aca,

Not sure this is a setting that can be adjusted or accessed via code. One option that comes to mind is using SendKeys, like so:

Please Login or Register  to view this content.

This could be linked to a button or key combination. It sends ALT+F8 to open the Macros dialog, then sends two TABs to get to the Macros In field, and finally types the letter T and then Enter so that "This Workbook" is selected.

Hopefully that can work for you.

[aca]

Thank you for this, Paul. I sense that your advice points to a possible solution; as it is, however, it doesn’t actually work; perhaps you can see where the glitch lies:

I create the macro, and locate it in This WorkBook.
But when executing it, already in its first step, the command, Application.SendKeys "%{F8}" -(just "{F8}" seems to work equally well) - opens a macro dialogue box which is not the right one: not the one that opens when I actually press ALT+F8, with different options for the “Macros In:” field, (and one more button on the right).

Please see this in the attached screenshots: The file “test1” is the one produced by the macro; while “test2” is the one I get when pressing ALT+F8, the one expected, the right one - (the language of my Excel is Spanish, sorry).