I'm not sure it you can *lock* the option permanently but Excel remembers the last option you select and will keep that selection until you change it again. So, if you change the setting to This Workbook, it will stay on This Workbook until you select another option again.