Cell Style Keeps Reappearing after being Deleted
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.
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 persists2. 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 persists3. 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. Read More
