Macros Run In "This Workbook" vs "All Open Workbooks"

[Janet Panighetti]

Dear Fellow Excelites,

I want to set a particular workbook to run macros in "This Workbook" only.

I've been trying to save it with that setting in Macro -> 'Run In:' but it
doesn't seem to stick.

I also want to be able to copy this workbook and have the new workbook also
run macros only in "This Workbook".

It keeps popping back to "All Open Workbooks" at some point.

Can you help me?

Thank you,
Janet

 

[Earl Kiosterud]

Janet,

The setting you're looking at is only to specify which macros are shown in the Tools - Macro
dialog. Any macro can still be run.

If this is about running the macros using that dialog, you might want to set up other ways
to run your macros. You can use buttons on the sheets, keyboard shortcuts or assign them to
menu items.