Macro that will delete any un used styles.
 

Any idea how to do this?

Thanks,
Tom

Macro that will delete any un used styles.
 

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

http://www.enhanceddatasystems.com/E...tyleMapper.htm

Regards,
Peter T

"Tom" wrote in message
...
Any idea how to do this?

Thanks,
Tom

Macro that will delete any un used styles.
 

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" wrote in message
...
Any idea how to do this?

Thanks,
Tom

Macro that will delete any un used styles.
 

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 *


"Tom" wrote in
message
...
Any idea how to do this?

Thanks,
Tom


.