LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Delete all user numberformat?

Hi there,


It seems that workbooks has a habit of accumulating tons of user
numberformats...

Instead of manually deleting the numberformats one by one, is it possible to
write a small macro that will delete all non-builtin user numberformats?


TIA,


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent Tab from User Delete Ardy Excel Worksheet Functions 2 September 9th 09 02:38 PM
delete every row where value equals user input Mitchell_Collen via OfficeKB.com Excel Programming 2 October 18th 07 07:10 PM
Allow user to delete cell ranges? Dave Mathew Excel Discussion (Misc queries) 3 May 7th 07 04:54 PM
Delete user-defined charts Lampman Charts and Charting in Excel 2 January 24th 07 01:49 AM
delete user define setting BNT1 via OfficeKB.com Charts and Charting in Excel 3 January 18th 07 07:00 PM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"