A Personal question about Personal.xls

[nowanda]

So... I've got all this code that works really nicely with all the different worksheets I need to work with but...

Others want to see how it works! What is the best way to 'publish' or provide the different modules to other people? These other people would like to run the functions themselves. Can I attach code to a worksheet permanently? What are the options?

Nowanda

 

[WillR]

Get them to add the code to their own personal.xls worksheet VBA module(s)

HTH

 

[Jim North]

Your best bet is to create an Excel add-in (XLA) and publish that.