Excel 2007: How to solve *Cannot run the macro...*

M

mfjbox

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
 
B

Bob Phillips

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)
 
M

mfjbox

I did enable the macro pop up when show after activated the .xlam

well, I have 2 files, which are: menu.xlam & mycode.xlsm
all the code menu stuffs (ribbon, auto_open, auto_close event) i put in
menu.xlam, while it will trigger to run code in mycode.xlsm

as i remember, i did manually enabled macro when poping up when i
activate menu.xlam, but when i click the ribbon that supposed to
trigger run the code in mycode.xlsm, it won't run. and showing the
error *Cannot run the macro 'mymacro.xlam'. The macro may not be
available in this workbook or all macro may be disabled*..

got the idea? please help me.

thanks
mfj
 
M

mfjbox

I did enable the macro pop up when show after activated the .xlam

well, I have 2 files, which are: menu.xlam & mycode.xlsm
all the code menu stuffs (ribbon, auto_open, auto_close event) i put in
menu.xlam, while it will trigger to run code in mycode.xlsm

as i remember, i did manually enabled macro when poping up when i
activate menu.xlam, but when i click the ribbon that supposed to
trigger run the code in mycode.xlsm, it won't run. and showing the
error *Cannot run the macro 'mymacro.xlam'. The macro may not be
available in this workbook or all macro may be disabled*..

got the idea? please help me.

thanks
mfj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call a macro from a xlam in a xlsm 3
Cannot display Add-in Macro list without going to VBA/Project 5
How to call Excel add-in macro from a button… 1
XLAM for global macros cannot be run 8
Excel 2007 Macro Security 2
Worksheet.Change macro doesn't run in 2007 11
In Access Can't Run Excel Macro Through Automation 5
Workbooks.Open suppresses MsgBox Displays when Macro is run 4

Top