Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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.