Analysis ToolPak - enable it programmatically?

[davidfox]

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

 

[Jim Rech]

Just record a macro as you do it manually.

--
Jim
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?action=getinfo&userid=29808
| View this thread: http://www.excelforum.com/showthread.php?threadid=495152
|

 

[davidfox]

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