2010 VBA trying to run macros from macros
In a VBA sub I copy a .xlxm file that contains macros I then want to run. I'm using Application.run "<macro name>" and VBA spits out runtime error 1004: Cannot run marco 'xxx'. The marco may not be available in this workbook or all marcos may be disabled.
I can run the marco manually in the copied file (after the run-time error) and the file is a xlsm file so cannot determine why the error code???
|