Invoke VBA: Cannot run the macro 'SumTwoNumbers'. The macro may not be available in this workbook or all macros may be disabled

Help Studio
1

Hello Team,

Tried running the macro via “Invoke VBA” inside an Excel Application scope.

But I get the error message as shown in the below image.

“Invoke VBA: Cannot run the macro ‘SumTwoNumbers’. The macro may not be available in this workbook or all macros may be disabled”

image
image1417×585 44.9 KB

image
image699×202 5.29 KB

Thanks
Minal Patil

2

Hi @minal.patil ,

Use this below vba code to sum the numbers,

Function SumTwoNumbers(Numberl As Integer,Number2 As Integer)As Integer
SumTwoNumbers = Numberl+Number2
End Function

Find the below screenshot for your reference,

image
image987×454 21.1 KB

Hope this may help you :slight_smile:

7 Likes
3

It’s working thanks

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.