+ Reply to Thread
Results 1 to 4 of 4

Remove all Links and convert to General

  1. #1
    Registered User
    Join Date
    03-31-2016
    Location
    Mesquite,Texas
    MS-Off Ver
    Office 365
    Posts
    13

    Remove all Links and convert to General

    Looking for a script to remove all links in a workbook and format everything on all tabs to "General"

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Remove all Links and convert to General

    So this removes the connections:

    Please Login or Register  to view this content.

    This will format each cell in all worksheets.
    Please Login or Register  to view this content.
    I also usually run some code to purge the cell STYLES because it is obnoxious when you have 60,000 of those and you want to use the default styles.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    03-31-2016
    Location
    Mesquite,Texas
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Remove all Links and convert to General

    Perfect! Do you have the code to purge as well?

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Remove all Links and convert to General

    This is what I have in my personal macro.

    Please Login or Register  to view this content.

+ 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. [SOLVED] How to Convert a General Number to Time
    By EverClever in forum Excel General
    Replies: 5
    Last Post: 10-04-2015, 12:01 PM
  2. Completely remove/delete all the external links (Break Links)
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:31 AM
  3. Removing Links - Is there a fast way to remove multiple links?
    By FLSnuffy in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-18-2012, 10:31 AM
  4. convert date column to general value
    By vikkam in forum Excel General
    Replies: 7
    Last Post: 01-08-2010, 12:27 PM
  5. Convert general format to date
    By NickC in forum Excel General
    Replies: 3
    Last Post: 02-06-2006, 11:30 AM
  6. Convert general text to date
    By windwebguy in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 06:49 PM
  7. Convert general to Time
    By Brent Hauver in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 11: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