Hyperlink in a threaded comment

[William]

Does anyone know if it's possible to automate the inclusion of a hyperlink in a threaded comment in Excel? I can add the URL as a comment easily enough using something like the following, but I haven't found a way to convert this to a link automatically.

Code: Select all

With ActiveCell
  .AddCommentThreaded "https://www.bing.com/"
  .CommentThreaded.Resolved = True
End With

I've tried adding all sorts of control characters to the text, but to no avail. It also seems there's no available xlDialog... for this, and I haven't found any way to use SendKeys. Using Record Macro with the manual link-activation process offers nothing useful.

Any ideas?

[HansV]

It looks like there is no support in VBA for hyperlinks in threaded comments yet.
You might submit a suggestion from within Excel: File > Feedback > Send a Suggestion.

[William]

Thanks Hans. I figured as much.