How to prevent add ins being included in distribution worksheet?

  • Thread starter Thread starter dochsm
  • Start date Start date
D

dochsm

The personal workbooks that I use on my machine use several home grown
add ins, some of which link to other workbooks on my machine.

However, the business workbooks that I produce and distribute to my
clients don't need those addins or the links.

How can I prevent my personal addins from becoming part of my business
workbooks so that my clients don't get warnings about links not being
updated?
 
Convert the formula with links to values is one way.

If I have a UDF (say) that is useful to others, I won't put it in my
personal.xl* workbook. That's for stuff that only I use.

If I want to share that UDF with others, I'll make a new addin and put the UDF
there.

Then I'll distribute that addin to each of the co-workers who need it.

And I'll tell them to put it in the same location on their harddrive -- like:

C:\excelutils\myaddin.xla

This makes any workbook that uses that UDF find the addin in the same location.

========
But if your problem is with links to other workbooks, you could put those other
workbooks in a folder on a common network drive -- and use the UNC path in your
links.
 
Back
Top