Macro that will delete any un used styles.

[Tom]

Any idea how to do this?

Thanks,
Tom

 

[Peter T]

Take a look at Robbin Hammond's "Style Mapper"

http://www.enhanceddatasystems.com/ED/Pages/ExcelStyleMapper.htm

Regards,
Peter T

 

[Rob Bovey]

Hi Tom,

My Excel Utilities add-in, which you can download from the web site
below, has a Delete Unused Styles feature. Note that it only checks
worksheet cells for style usage. If a style is not used on any worksheet but
gets applied by a VBA macro, for example, that style will be deleted.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *

 

[Tom]

Thanks guys!

Tom

-----Original Message-----
Hi Tom,

My Excel Utilities add-in, which you can download from the web site
below, has a Delete Unused Styles feature. Note that it only checks
worksheet cells for style usage. If a style is not used on any worksheet but
gets applied by a VBA macro, for example, that style will be deleted.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *





.