The key part may be ... macro may be disabled.

I often find that when I open an xlam, as the macro warning defaults to
disabled, I accidentally, automatically disable macros.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Greetings,

This weeks, I'm trying to port my vba code from excel 2003 to excel
2007
beta2. everything were okay until i got this error...

*Cannot run the macro 'mymacro.xlam'. The macro may not be available in
this workbook or all macro may be disabled*

Its' kinda weird since I already put my .xlam and .xlsm in trusted
location that allow to run macro.

Is anyone can help this out, thanks in advance

mfj

*i've allready search old post, i got none