| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analysis ToolPak - enable it programmatically?
I have a spreadsheet that requires the Analysis ToolPak add-in. But our IT Department keeps (inadvertently?) turning it off every tim they push out new group policies. Is there a way to enable it from within a piece of VBA code or a macro -- davidfo ----------------------------------------------------------------------- davidfox's Profile: http://www.excelforum.com/member.php...fo&userid=2980 View this thread: http://www.excelforum.com/showthread.php?threadid=49515 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Analysis ToolPak - enable it programmatically?
Just record a macro as you do it manually.
-- Jim "davidfox" wrote in message ... | | I have a spreadsheet that requires the Analysis ToolPak add-in. | | But our IT Department keeps (inadvertently?) turning it off every time | they push out new group policies. | | Is there a way to enable it from within a piece of VBA code or a macro? | | | -- | davidfox | ------------------------------------------------------------------------ | davidfox's Profile: http://www.excelforum.com/member.php...o&userid=29808 | View this thread: http://www.excelforum.com/showthread...hreadid=495152 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Analysis ToolPak - enable it programmatically?
Great, I didn't know macros could record what you do in the menus. The code ended up being: AddIns("Analysis ToolPak").Installed = True Thanks.. ..d -- davidfo ----------------------------------------------------------------------- davidfox's Profile: http://www.excelforum.com/member.php...fo&userid=2980 View this thread: http://www.excelforum.com/showthread.php?threadid=49515 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enable analysis toolpak | Excel Discussion (Misc queries) | |||
| enable analysis toolpak | Excel Discussion (Misc queries) | |||
| Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
| Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Hybrid Mode
