SOLVED

Cell Style Keeps Reappearing after being Deleted

Copper Contributor

I'm using Excel under a M365 Home subscription (Version 2408 Build 16.0.17928.20114 64-bit)

 

The Problem:

Even in brand new, blank workbooks, whenever I delete the default cell styles for "Hyperlink" and "Followed Hyperlink," these cell styles will reappear and apply themselves on their own the next time a hyperlink is created or followed in the workbook. This occurs whether the hyperlink is created via VBA, cell formula, or the "insert hyperlink" wizard/dialogue. 

 

What I've Tried:

1. I have turned off the "AutoFormat As You Type" option to automatically replace "Internet and Network paths with hyperlinks;" the problem persists

2. I have deleted all cell styles (other than the "normal" cell style, which cannot be deleted) in the active workbook and my PERSONAL.xlsb workbook; the problem persists

3. I have used VBA to delete the cell styles (as compared to just right clicking the cell style and selecting "delete"); the problem persists

 

The Question:

Any idea how to prevent Excel from automatically re-adding the "Hyperlink" and "Followed Hyperlink" cell styles after they've been deleted? I want hyperlinks to exhibit NO automatic formatting whatsoever.

2 Replies
best response confirmed by BenK1550 (Copper Contributor)
Solution

@BenK1550 

I don't think you can do that. Instead, you could modify the Hyperlink and Followed Hyperlink styles to have automatic font color and no underlining.

Thank you for the answer; this is the workaround I am using... I suppose I am just surprised that there is no way to disable automatic formatting of links or the automatic creation of cell styles altogether. Thanks again.
1 best response

Accepted Solutions
best response confirmed by BenK1550 (Copper Contributor)
Solution

@BenK1550 

I don't think you can do that. Instead, you could modify the Hyperlink and Followed Hyperlink styles to have automatic font color and no underlining.

View solution in original post