Macro not working on button click

[nando88]

I have a macro that works correctly when I run it from developer mode, but when I try to run the macro by clicking on a shape that has the macro assigned to it, it does not work.
Can someone please tell me how can I fix this error, since I need to be able to run my macro by clickin on the shape I have created.
Thanks in advance.

 

[Joe4]

What does the macro look like (please post the code)?
How does it not work? Is it not running at all, or are you getting errors?
If you are getting errors, what are the exact error messages and which lines of code does it highlight when you click "Debug"?

 

[nando88]

I am not getting any errors, since I was able to successfully run the macro by pressing F5 in the developer tab, but when I try to run the macro by clicking on the shape I assigned it to, it doesn't work.

Do you know what might be the issue?
Please let me know.
Thanks.