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

  • Thread starter Thread starter Janet Panighetti
  • Start date Start date
J

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
 
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.
 
Back
Top