You are not logged in. Your edit will be placed in a queue until it is peer reviewed.
We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.
-
I actually tried using the Style Painter/Update Style method, but got some fairly unexpected results... First, when I pasted the style, it actually changed both the font and the color to something completely different from both the original and the source, and also removed the underline. Pasting the style on the same text a second time worked though. But then when I did "Update Hyperlink to Match Selection", it did alter the Hyperlink Style, but it also again changed the font of the text to yet another seemingly random font. I will try the VBA method though, it looks like that should work.– Dan HendersonCommented Jun 12, 2015 at 4:37
-
Yeah style painter is notoriously horrible. It might have been worth ensuring the underlying style for both the source/target paragraph was set to Normal with no other formatting other than Hyperlink on it. But other things could still go wrong. I should probably make the VBA method the first in this answer.– snoopenCommented Jun 12, 2015 at 4:58
-
Sorry for "abandoning" this question - between competing assignments and the passage of time, I lost track of which document this happened in, and so I haven't had the chance to go back, find it again, and apply this fix. But, having some familiarity with VBA and Office, I'm confident enough that this will do exactly what I need, that I'm accepting your answer on the benefit of the doubt.– Dan HendersonCommented Jul 23, 2015 at 20:18
-
Since I've already upvoted and accepted your answer, I can't do more than that, but I thought you might be interested to know that I finally had this come up again and I used your VBA solution, which worked perfectly. One small note, though, the keyboard shortcut for the VBA window is Alt-F11, not Alt-F12. Since I can't make an edit suggestion for a single character, you'll have to make that edit as the post author.– Dan HendersonCommented Feb 3, 2017 at 16:52
-
1Glad to hear it worked for you! Thanks for pointing out my error, I've fixed the keyboard shortcut.– snoopenCommented Feb 3, 2017 at 20:38
Add a comment
|
How to Edit
- Correct minor typos or mistakes
- Clarify meaning without changing it
- Add related resources or links
- Always respect the author’s intent
- Don’t use edits to reply to the author
How to Format
-
create code fences with backticks ` or tildes ~
```
like so
``` -
add language identifier to highlight code
```python
def function(foo):
print(foo)
``` - put returns between paragraphs
- for linebreak add 2 spaces at end
- _italic_ or **bold**
- indent code by 4 spaces
- backtick escapes
`like _so_`
- quote by placing > at start of line
- to make links (use https whenever possible)
<https://example.com>
[example](https://example.com)
<a href="https://example.com">example</a>
How to Tag
A tag is a keyword or label that categorizes your question with other, similar questions. Choose one or more (up to 5) tags that will help answerers to find and interpret your question.
- complete the sentence: my question is about...
- use tags that describe things or concepts that are essential, not incidental to your question
- favor using existing popular tags
- read the descriptions that appear below the tag
If your question is primarily about a topic for which you can't find a tag:
- combine multiple words into single-words with hyphens (e.g. windows-7), up to a maximum of 35 characters
- creating new tags is a privilege; if you can't yet create a tag you need, then post this question without it, then ask the community to create it for you