Workbook_Activate and Workbook_Open

We have a macro in our old 2003 file that runs when excel opens. It loads in our addin buttons. Now with 2007 it will not run the macro because of the security. If someone clicks to allow the macros to run it will not put the addins in. How can we get past this, here is the old code:

Please Login or Register  to view this content.

Secondly we have a protection macro that runs when the file opens, but this gets bypassed to leaving stuff unprotected. Here is the start of that code:

Please Login or Register  to view this content.

Can I change that to _WhenSAVE or something like that?
_Close does not work because it does it after you have saved.

Thanks in advanced

Originally Posted by pike

Hi caliskier
Go to Developer>Macro Security>Trusted locations and add the folder where you have the file

Thanks, thanks thanks!!!

This should save some pain, but I am getting security errors (current settings stuff) that I am trying to fix. any ideas?

Ha, just got past that, no more help needed... I hope