LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? CPW Excel Worksheet Functions 1 January 21st 10 06:31 PM
Automatically insert time in excel but not automatically updated NeueN Excel Worksheet Functions 4 December 25th 08 07:29 AM
How to enable Macro automatically ub Excel Worksheet Functions 3 January 31st 08 06:22 PM
Enable macros automatically for a workbook Diane Alsing Excel Discussion (Misc queries) 4 February 16th 05 05:48 PM
Automatically enable macros for particular template Bryan Linton Excel Programming 1 February 2nd 05 10:31 PM


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"