View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
danswa danswa is offline
external usenet poster
 
Posts: 1
Default Enable add-in automatically


Hi,

I have a workbook that uses the NETWORKDAYS function, which is pat of
the Analysis Toolpack add-in.

The problem is, when the workbook is opened on another PC, then the
NETWORKDAYS appear as #NAME. It is very annoying to have to explain
every user to turn on the add-in.

Is there a way to automatically (preferably without the use of VBA or
macro's) have the add-in enabled when the document is opened?

If there is absolutely no way, then what is the easiest way to use VBA
or a automatic start-up macro to enable the add-in?


--
danswa
------------------------------------------------------------------------
danswa's Profile: http://www.excelforum.com/member.php...o&userid=31267
View this thread: http://www.excelforum.com/showthread...hreadid=511708