Thanks Rob, actually I did this about 20 Mins after I posted so I've
worked it out already. I also had to set the Analysis ToolPak to false
then true for it work. Excel still thinks that is added upon entry.

Also, why was this posted somewhere else other than google groups? I
can't reply to the the dev forums you ended up posting it too? why do
that for? I specifically posted to google and I would hope it would
stay that way in future posts.