JTracker
05-03-2007, 08:04 PM
I have a macro that I am using in one workbook that conflicts with another workbook.
When I go to the Tools-Macro (Alt-F8), I can select the Macro and set - Macros in: to "This Workbook" and all is fine.
If I shut down Excel and re-open the workbook, I find the "Macros in:" returns to a default of "All Open Workbooks".
How can I ensure the macro runs ONLY in it's own workbook.
Thanks for everyone's help.
:banghead: JTracker
When I go to the Tools-Macro (Alt-F8), I can select the Macro and set - Macros in: to "This Workbook" and all is fine.
If I shut down Excel and re-open the workbook, I find the "Macros in:" returns to a default of "All Open Workbooks".
How can I ensure the macro runs ONLY in it's own workbook.
Thanks for everyone's help.
:banghead: JTracker