Arghhhh....
When calling a macro in another workbook via a active x command button I am getting a;
Run time error 1004 - cannot run the macro "macroname". The macro may not be available in this workbook or all macros may be disabled.
It works fine it assigned to form button but I would like to run it through the command button so I can parse some code before running the macro.
Got me beat! Changed security settings to low and the location in definitely loaded into "trusted locations".
I can't see any other reason as to why it won't run?
Anyone have any bright ideas?
When calling a macro in another workbook via a active x command button I am getting a;
Run time error 1004 - cannot run the macro "macroname". The macro may not be available in this workbook or all macros may be disabled.
It works fine it assigned to form button but I would like to run it through the command button so I can parse some code before running the macro.
Got me beat! Changed security settings to low and the location in definitely loaded into "trusted locations".
I can't see any other reason as to why it won't run?
Anyone have any bright ideas?
Last edited: