如何制作所有用户使用的Excel自定义标签。

本文介绍了如何制作所有用户使用的Excel自定义标签。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经使用customUI工具创建了customTab，并在该选项卡中我放置了带有1个按钮的功能区。我正在将导出Excel工作表发送到硬盘。它工作正常但现在我想要自定义选项卡可用于所有excel文件。怎么样才能帮到我。

I have created customTab using customUI tool and in that tab i placed ribbon with 1 button.There i am doing export excel sheet to harddisk.Its working fine but now i want to do my custom tab is availble to all excel files.how to make it please help me.

Sub Export(control As IRibbonControl) Dim OrigName As String OrigName = ActiveWorkbook.FullName Application.DisplayAlerts = False ActiveWorkbook.SaveAs "D:\attach\" + ActiveWorkbook.Name ActiveWorkbook.SaveAs OrigName MsgBox "File exported into D:\attach" End Sub

推荐答案

您必须将工作簿另存为 Excel Add -in [ ^ ]然后将其加载到加载项集合中。接下来，每个工作簿都可以使用自定义选项卡及其控件。 You have to save a workbook as an Excel Add-in[^] then load it into Add-ins collection. Next, a custom tab and its controls will be available for each workbook.