如何制作所有用户使用的Excel自定义标签。 [英] How to make excel custom Tab used by all users.

问题描述

我已经使用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.

这篇关于如何制作所有用户使用的Excel自定义标签。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！