I have a workbook where I run a macro from a shape.
This is done by manually assigning the macro in the "assign macro" dialogue box.
The macro needs parameters, so the call is: NameOfWorkbook.xlsm!'NameOfMacro "parameter"'
When I open the workbook and tries to run the macro from the shape, I get the error message as in the title.
However If I press the shape again, it works just fine. No matter how many times I run the macro from this shape or other similar shapes afterwards there are no problems. It is only the first time i click it that there are problems.
I have tried to make the function public, but with no change in behaviour.
I have tried to change the security settings, but with no change in behaviour.
It should also be mentioned that I've read a lot of previous posts on this site and other with the same error, but none of the suggested solutions worked for me.
Any help or comments would be greatly appreciated
Thanks in advance
This is done by manually assigning the macro in the "assign macro" dialogue box.
The macro needs parameters, so the call is: NameOfWorkbook.xlsm!'NameOfMacro "parameter"'
When I open the workbook and tries to run the macro from the shape, I get the error message as in the title.
However If I press the shape again, it works just fine. No matter how many times I run the macro from this shape or other similar shapes afterwards there are no problems. It is only the first time i click it that there are problems.
I have tried to make the function public, but with no change in behaviour.
I have tried to change the security settings, but with no change in behaviour.
It should also be mentioned that I've read a lot of previous posts on this site and other with the same error, but none of the suggested solutions worked for me.
Any help or comments would be greatly appreciated
Thanks in advance