超链接到没有 [英] excel hyperlink to nothing

问题描述

我有很多超链接，我想为每个链接分配一个宏，Worksheet_FollowHyperlink仅捕获插入的超链接，而不捕获HYPERLINK（）函数。所以我希望我的插入超链接是没有提到的，所以当我按下它们什么也没有发生。或者我想让他们自己来。但是当我只是复制一个单元格，它仍然指父母的单元格。所以我必须编辑一个新的，所以它指的是它的新单元格。而且我也有hundreeds的超链接也被复制和编辑。我需要这个，因为我不想超链接跳过我的父级超级链接的单元格。

I've got a lot of hyperlinks and I want to assign a macros to each of them and Worksheet_FollowHyperlink captures only Inserted Hyperlinks but not the HYPERLINK() function. So I want my Inserted Hyperlinks refer to nothing so when I press them nothing happens. Or I want them to refer themselves. But when I just copy one to another cell it still refers to its parents cell. So I have to edit a new one so it refers to its new cell. And I've got hundreeds of hyperlinks to be copied and edited as well. I need that because I don't want the hyperlinks skip me to the parent hyperlink's cell.

提前感谢

推荐答案

你最好使用HYPERLINK（）函数。你可以使用它，你想要这样：

You will be better off using the HYPERLINK() function. You can use it for what you want like this:

=HYPERLINK("#HyperlinkClick()", "Text you want to Display")

请注意开始时的＃。 这很重要。

现在创建一个名为HyperlinkClick的功能：

Now create a function called HyperlinkClick:

Function HyperlinkClick()

    Set HyperlinkClick = Selection
    'Do whatever you like here...
    MsgBox "You clicked on cell " & Selection.Address(0, 0)

End Function

就是这样。

这篇关于超链接到没有的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！