This is for Excel 2010.
Is there a way to generate a list of the styles used in a workbook, together with their properties?
My intention is to help the user recognize what a style means by creating a styles key on a separate worksheet.
For example, if Workbook A has 45 styles in use throughout (most of them custom styles), I would like to be able to generate a list of those styles.
Basically, the list would include the name of the style as listed in the style gallery and an example of the style in use.
Ideally, the list would include all the properties of the style by column:number style, alignment, font, fill, border, protection, and example of the style in use.
Can anyone suggest a way to generate all or part of this style key?
Thank you for your advice in advance.
Is there a way to generate a list of the styles used in a workbook, together with their properties?
My intention is to help the user recognize what a style means by creating a styles key on a separate worksheet.
For example, if Workbook A has 45 styles in use throughout (most of them custom styles), I would like to be able to generate a list of those styles.
Basically, the list would include the name of the style as listed in the style gallery and an example of the style in use.
Ideally, the list would include all the properties of the style by column:number style, alignment, font, fill, border, protection, and example of the style in use.
Can anyone suggest a way to generate all or part of this style key?
Thank you for your advice in advance.
Last edited:
