In the ThisWorkbook code module, in the _Open event is the primary place, but you can flip the settings on and off if you switch between open workbooks

Capture.JPG