"Cannot run the macro" error

Hello,

I've created a macro to run regression analysis under the data analysis option. The first time I enter my keyboard shortcut, the macro works fine. When I try re-entering the shortcut, I get the following error:

"cannot run the macro the macro may not be available in this workbook or all macros may be disabled"

Here is my code:

Sub Regression()
'
' Regression Macro
'
' Keyboard Shortcut: Ctrl+Shift+R
'
    Sheets("Data Analysis-Reps").Select
     Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$I$5:$I$36"), _
        ActiveSheet.Range("$A$5:$A$36"), False, False, , ActiveSheet.Range("$D$60") _
        , False, False, False, False, , False
End Sub

When I choose to debug the error, "application.run" to the last "false" is highlighted in yellow so this is where I assume the error is. I'm just not sure why the macro would run fine the first attempt, then fail after that.

Any help or advice would be appreciated!

Thanks

Originally Posted by gmr4evr1

Is it possible that the problem is the double commas between False and ActiveSheet.Range("$D$60") and between the last 2 False?
Although, that may not explain the cannot run the macro error.

Thanks for the response, but that is not causing the issue.

Originally Posted by gmr4evr1

Probably not the problem, but has the macro setting been changed somehow? If that's not it, is that macro stored in a file that isn't open?

No settings have been changed and the macro is stored only in the file I'm trying to run it in.

Originally Posted by gmr4evr1

What is the file extension of the file?

.xlsm is the extension

Originally Posted by gmr4evr1

Your code is calling for an .xlAm file, could this be the error?

I believe XLAM is the application being run. Like I mentioned previously, the macro works the first time, then subsequently fails.

Originally Posted by gmr4evr1

Is the macro named regress or regression?

Regression

Originally Posted by gmr4evr1

Just taking a stab here, but, the "Application.Run" line is calling for !Regress.....should it be !Regression?

Hah, thanks I tried that too but to no avail!

Originally Posted by gmr4evr1

Well dang it! When I copied and pasted your code to one of my workbooks and changed it to !Regression, I didn't get the "cannot run the macro" error anymore. Of course I got another error, but I think that is because I don't have all the required info.

Do you get the same problem where it works the first time then stops working after that?