C coplexx New Member Feb 6, 2013 #1 Assign Macro dialog box defaults to 'Macros in: All Open Workbooks'. How can it be defaulted to show This Workbook?
Assign Macro dialog box defaults to 'Macros in: All Open Workbooks'. How can it be defaulted to show This Workbook?
Luke M Excel Ninja Staff member Feb 6, 2013 #2 Change the dropdown once, then close the dialogue via the Red X in top right corner.
C coplexx New Member Feb 6, 2013 #3 It works for the session, but every time I start Excel again it goes back to the All Open Workbooks default. I was wondering if there was a registry setting or something that I could change to permanently set it to This Workbook. thx Michael
It works for the session, but every time I start Excel again it goes back to the All Open Workbooks default. I was wondering if there was a registry setting or something that I could change to permanently set it to This Workbook. thx Michael
