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:

Private Sub Workbook_Activate()
'runs the toolbar
Run "ForecastToolbar"

End Sub
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:

Private Sub Workbook_Open()
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