+ Reply to Thread
Results 1 to 3 of 3

How to delete ALL styles in a workbook?

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    NYC
    MS-Off Ver
    2016
    Posts
    1

    How to delete ALL styles in a workbook?

    I have created a set of custom cell styles in Workbook A that I want to add to Workbook B. Workbook B currently has all the default styles. When I copy cells from Workbook A to Workbook B, the custom styles are copied, which is great. However, Workbook B still has all those default styles. How can I delete all the default styles? I have seen other threads on deleting everything besides the built-in styles.

    Thank you!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: How to delete ALL styles in a workbook?

    You can't.
    Rory

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to delete ALL styles in a workbook?

    I have a template workbook (Book.xltx) with a very small number of styles, and a macro that deletes most styles from an open workbook and copies the attributes of those that remain with those from my default styles. (It's the first thing I run when opening most other peoples' workbooks). Happy to post that if you're interested.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Delete Cell Styles
    By mikeTRON in forum Excel General
    Replies: 1
    Last Post: 07-15-2016, 12:08 PM
  2. How do I delete styles?
    By Dave H in forum Excel General
    Replies: 18
    Last Post: 02-13-2015, 04:56 PM
  3. Too much cell styles need to delete by VBA
    By terryliu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2015, 02:37 AM
  4. [SOLVED] Delete all non-custom styles
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 07:27 PM
  5. How to delete cell styles?
    By meyestone in forum Excel General
    Replies: 7
    Last Post: 01-11-2012, 04:56 PM
  6. [SOLVED] Macro to delete un used styles in a workbook!
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2005, 05:06 PM
  7. [SOLVED] Macro that will delete any un used styles.
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1