Add tablestyle to default gallery for anything opened in Excel 2010

I've been trying to add my own tablestyles to excel 2010 via vba for any workbook I create or open. I can get it t开发者_如何学Pythono work with an XLA file in the startup for new sheets that open when Excel starts, but I can't make the gallery contain my style for any other sheet. Driving me nuts!

how does you code is executed within your XLA ? i mean, from which event ?

If your XLA is only loaded by default (i.e. in Excel default folder C:\Program Files...), then it will be loaded only for new Workbooks because Excel relies on the default template MyWorkbook (and loads the defaults XLA).