This used to be:Can you turn off the "autofit column widths on update" by default?

I'm making a tabulation in a worksheet that is basically a collection of multiple pivot tables. But whenever I add a new pivot table to the worksheet, it elongates all columns due to the autofit option. Can I have the "autofit column widths on update" turned off by default?

I found a solution on the internet: http://www.get-digital-help.com/2012...es-in-a-sheet/

One problem with this approach is that this works only with your current workbook.

How do you make a VBA active for ALL workbooks?