runing macro of imported module.

[Guest]

hi,
i added a module to excel file by import it from other file.
now when i try to run it from my menu it give me an error :"cannot run the
macro...the macro may not be available in this workbook or all macros
disabled".
the macros are not disabled, i also see it under the macro window under the
same name but with the module name before (moduleName.MacroName)
what shouls i done in order to be anable to continue running it from the menu.
(i still need the option to run it in both cases -with or without the module
name before...)
thanks

 

[Leith Ross]

hi,
i added a module to excel file by import it from other file.
now when i try to run it from my menu it give me an error :"cannot run the
macro...the macro may not be available in this workbook or all macros
disabled".
the macros are not disabled, i also see it under the macro window under the
same name but with the module name before (moduleName.MacroName)
what shouls i done in order to be anable to continue running it from the menu.
(i still need the option to run it in both cases -with or without the module
name before...)
thanks

Hello Miri,

The macro may have references to either specific sheet name(s) or
another workbook(s). Not all macros are written to run with other
workbooks or on other machines. Check your code for these issues.

Sincerely,
Leith Ross