既然您已经为WorkbookBeforeClose、WorkbookOpen和WorkbookActivate事件添加了调用该函数的委托，那么您可以在这些事件触发时更新Ribbon的启用状态。以下是一个简单的示例，展示了如何在这些事件中更新Ribbon的启用状态： 首先，在Ribbon代码文件中，添加一个名为`UpdateRibbonEnabledState`的方法，用于更新Ribbon的启用状态： ```csharp public void UpdateRibbonEnabledState() { // 检查是否有打开的Workbook bool hasOpenWorkbook = Application.Workbooks.Count > 0; // 更新Ribbon按钮的启用状态 ribbonButton1.Enabled = hasOpenWorkbook; ribbonButton2.Enabled = hasOpenWorkbook; // ... 更多的Ribbon控件 } ``` 接下来，在您的Add-in代码文件中，为WorkbookBeforeClose、WorkbookOpen和WorkbookActivate事件添加事件处理程序，并在这些事件触发时调用`UpdateRibbonEnabledState`方法： ```csharp private void ThisAddIn_Startup(object sender, EventArgs e) { // 添加事件处理程序 Application.WorkbookBeforeClose += Application_WorkbookBeforeClose; Application.WorkbookOpen += Application_WorkbookOpen; Application.WorkbookActivate += Application_WorkbookActivate; } private void ThisAddIn_Shutdown(object sender, EventArgs e) { // 移除事件处理程序 Application.WorkbookBeforeClose -= Application_WorkbookBeforeClose; Application.WorkbookOpen -= Application_WorkbookOpen; Application.WorkbookActivate -= Application_WorkbookActivate; } private void Application_WorkbookBeforeClose(Workbook wb, ref bool cancel) { // 更新Ribbon启用状态 UpdateRibbonEnabledState(); } private void Application_WorkbookOpen(Workbook wb) { // 更新Ribbon启用状态 UpdateRibbonEnabledState(); } private void Application_WorkbookActivate(Workbook wb) { // 更新Ribbon启用状态 UpdateRibbonEnabledState(); } ``` 这样，在事件发生时，您的Ribbon功能将根据Workbook的数量自动启用或禁用。 以上为腾讯混元大模型提供,仅提供参考价值. ---杨不易呀自动回复... 展开详请