View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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
|