ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Publishing VBA Functions (https://www.excelbanter.com/excel-programming/289789-publishing-vba-functions.html)

Ralph Shade

Publishing VBA Functions
 
Can someone give me a point to instructions on making a
user defined VBA function generally available, both for an
individual user and for a group of users?
Thanks,
Ralph

Gord Dibben

Publishing VBA Functions
 
Ralph

Good method is to save the workbook with the UDF as an Add-in(*.xla)

Distribute that to users or make it available from a folder on the network
server.

You could also export the module as a *.bas file and get your users to import
to a workbook but that could get unwieldy and would be dependent upon your
users' expertise.

Gord Dibben Excel MVP

On Fri, 30 Jan 2004 14:28:46 -0800, "Ralph Shade" wrote:

Can someone give me a point to instructions on making a
user defined VBA function generally available, both for an
individual user and for a group of users?
Thanks,
Ralph




All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com