For Sub's tied to toolbars an Addin - as said by JMax - would be my choice. For formulae specific to your business a regular empty Excel file with one or more modules containing Function Xxx(), placed in the Autostart folder would be sufficient.
A server directory which is added to the user's path of Autostart folders is an easy way to auto-distribute formulae.
I am using the latter for instance for IP address calculations
发布评论
评论（2）
恕我直言，最简单的方法是使用您的代码创建一个加载项并将其提供给用户。
请参阅ozgrid 上的此链接了解如何构建插件。
IMHO, the easiest way is to create an add-in with your code and give it to the users.
See this link on ozgrid to learn how to build addins.
对于与工具栏绑定的 Sub，我的选择是 Addin（正如 JMax 所说）。对于特定于您的业务的公式，将包含一个或多个包含 Function Xxx() 的模块的常规空 Excel 文件放置在 Autostart 文件夹中就足够了。
添加到用户的自动启动文件夹路径中的服务器目录是自动分发公式的简单方法。
我使用后者来计算 IP 地址
For Sub's tied to toolbars an Addin - as said by JMax - would be my choice. For formulae specific to your business a regular empty Excel file with one or more modules containing Function Xxx(), placed in the Autostart folder would be sufficient.
A server directory which is added to the user's path of Autostart folders is an easy way to auto-distribute formulae.
I am using the latter for instance for IP address calculations