This is probably a simple task to complete, but for some reason I am having difficulty.
I have a macro saved in ThisWorkbook named MyMacro.
On a sheet in ThisWorkbook I added an Active X button. When I go the VBA coding for the Active X button I just want it to run MyMacro. I use the code Call MyMacro in the VBA coding for the Active X button. This fails everytime.
Why is this happening? How can I assign the macro MyMacro to the Active X button using VBA coding?