VBA runtime 1004 error:

[joecom88]

Hi all: I am getting:

vba runtime error 1004 cannot run the macro. the macro may not be available in this workbook or all the macros may be disabled.

when I attempt to run through a module that runs another module within the xlsm. I can run personal.xlsb modules successfully. I've tried about a dozen fixes to no avail.

Application.Run "Portfolio_Analytics_Macros_Pro.xlsm!pgSUMMARY"

is the specific code in question though I use Application.Run many times throughout.

Stumped on this and any help would be greatly appreciated.....
Thanks

 

[ParamRay]

.
.

If the macro pgSUMMARY is in a module within the same workbook as the calling macro, then Application.Run "pgSUMMARY" should work fine.

Check that:
(1) pgSUMMARY is not declared as a Private Sub;
(2) the module containing pgSUMMARY is does not start with Option Private Module; and
(3) pgSUMMARY doesn't require any arguments (i.e. parameters within the parentheses).

If it fails any of the above conditions, then that will cause an error.

 

[joecom88]

Hi: thanks for the reply. I verified all the items below and it still doesn't work.
If it helps, the modules live in one worksheet and fills in another worksheet template.
There is an older version that works fine. The macro sheet and template both live on the network, though running from C drive doesn't fix it.

Any other thoughts it might be? Could it be something in the environment?

Thanks, Joe

.
.

If the macro pgSUMMARY is in a module within the same workbook as the calling macro, then Application.Run "pgSUMMARY" should work fine.

Check that:
(1) pgSUMMARY is not declared as a Private Sub;
(2) the module containing pgSUMMARY is does not start with Option Private Module; and
(3) pgSUMMARY doesn't require any arguments (i.e. parameters within the parentheses).

If it fails any of the above conditions, then that will cause an error.