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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index function in vba 3
excel spreadsheet functions written in vba 1
Access ConcatRelated() Function Not Working 0
Format change with VBA language dependent? 5
EXcel Functions in VBA 5
Multiple User Defined Categories in Insert Function Form 2
To SQL Expert: VBA Function that Calls SQL Query 3
vba macro that allows insertion of symbols at cursor 0

Back
Top