Sep 14 2024 07:44 AM
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.
Sep 14 2024 08:07 AM
SolutionI 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.
Sep 14 2024 08:22 AM
Sep 14 2024 08:07 AM
SolutionI 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.