Publishing VBA Functions

  • Thread starter Thread starter Ralph Shade
  • Start date Start date
R

Ralph Shade

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
 
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
 
Back
Top