Automate excel add in check box

[Greg Leimbeck]

I am trying to automate an excel add in for everyone in my company. So far I
have written a script to copy the function into the Office\AddIns folder.
The script is running fine and the function shows up in the Tools -> Add Ins
folder, but it is not checked. I need to find out a way to automate the
checking of that box.

Any ideas?

TIA

Greg Leimbeck

 

[Greg Leimbeck]

There has to be a way to automate this. I just paid Microsoft $35.00 to tell
me that it is "impossible" but I know that it could probably be done through
a VBS script. If someone could help me out with that I would be extremely
grateful.

 

[Greg Leimbeck]

Awesome...Thanks for all of the help.

There has to be a way to automate this. I just paid Microsoft $35.00 to tell
me that it is "impossible" but I know that it could probably be done through
a VBS script. If someone could help me out with that I would be extremely
grateful.