Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Nov 16 '10 at 14:44

This question came from our site for professional and enthusiast programmers.

1 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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.