Are you in XP, or 2003? I did not know that XP asked these questions, but I do know that 2003 does. Anyway, the only thing I know to do is within the database, with the database window active, use the Tools menu, Macro option, then the Security... option. Then select the "Low" option on the Security Level tab. I think this will fix it, but I'm not sure.
You could converting ALL your Macros into VB using Modules by Convert Macro to VB. Although this is a pain, it is a long term solution and a "good habit" to get into. It took me a good 6 months only because there are 100's of scripts - but I'm still gald I converted.