| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that will delete any un used styles.
Any idea how to do this?
Thanks, Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some unknown Cell styles are shown in cell styles | Excel Worksheet Functions | |||
| How do I delete multiple cell styles? | Excel Discussion (Misc queries) | |||
| Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
Hybrid Mode
