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

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
|

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