How can I define a global cell style in Excel 2010?

Question

It is pretty straightforward to create new cell styles in Excel 2010. My problem is that the new style I create is only available for that spreadsheet.

How can I create a global cell style that will be there with the Excel default styles each time I create a new spreadsheet? Is this possible?

Answer 1

The Styles object is a member of Workbook not Application. There is no way AFAIK to add a style to the built-in collection (the BuiltIn property is readonly).
But you could make a style you create available to new workbooks by including your new styles in a workbook template.
To modify the default template start with a blank workbook, create the styles you want, then save the workbook in your XLSTART directory as a template called Book.XLTX or Book.XLT