Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
runing macro of imported module.
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 -- Miri Tz. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
runing macro of imported module.
On Oct 9, 6:22 am, Miri wrote:
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 -- Miri Tz. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imported Visual Basic Module - Save Macros for use in Excel | Excel Discussion (Misc queries) | |||
Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
Runing part of the macro | Excel Programming | |||
Error when runing macro to create pivot table | Excel Programming | |||
Automatically runing a macro | Excel Programming |