Excel加载启动时 [英] Excel add-in on startup

问题描述

我创建了一个使用Visual C＃微软Excel加载英寸当我第一次创建的解决方案，它包括一个名为ThisAddIn_Startup功能。我下面的代码添加到该功能：

I am creating an add in for Microsoft Excel using Visual C#. When I first created the solution, it included a function called ThisAddIn_Startup. I added the following code to this function:

private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
    MessageBox.Show("Startup");
}

消息框不显示在安装中添加和启动Microsoft Excel中。事实上，没有在此功能时加载的插件。这是第一次从字面上创建后，我到这个新项目做出的唯一改变。为什么不工作？

The message box does not show upon installing the add in and starting Microsoft Excel. Indeed, NOTHING in this function works when the add in loads. This is literally the only change I've made to this new project after first creating it. Why won't it work?

推荐答案

在开发外接程序对Excel中有时会创建的错误将触发Excel中禁用的AddIn 。如果是这样，你需要去到Excel，转到文件/选项，然后选择加载项。在屏幕的左下方有下拉列表以标签管理。选择禁用项目，然后点击搜索。如果您的工具被禁用，您将有看到它，你可以重新启用它。这是从Office 2010中新的版本可能重新排列了这一点，我不知道一个例子。

When developing AddIn's for Excel you will sometimes create bugs that will trigger Excel to disable the AddIn. If so you need to Go into Excel, go to File / Options and select Add-Ins. At the lower left of the screen there is a drop down list with the label "Manage:". Select "Disabled Items" and click Go button. If your tool is disabled you will see it there and you can re-enable it. This was an example from Office 2010. The new version might have rearranged this, I don't know.

这篇关于Excel加载启动时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！