开发者

Add tablestyle to default gallery for anything opened in Excel 2010

开发者 https://www.devze.com 2023-03-23 10:10 出处：网络

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 wh

相关专题：excel

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).