Cannot figure out what is going on and hoping for expert advice.
On my desktop, I have created a workbook with command buttons and graphic shapes and have assigned macros to them. With the command buttons, in the Developer mode I click on "View Code" and assign macros there. No problems.
Also on the desktop, I have inserted several shapes and have assigned macros. I right click on the shape and then click "Assign Macro". No problems.
Now I go over to my laptop and open the same workbook. The command button shapes work fine. But the macros assigned to the shapes do not run. I get error message ... "Cannot run the macro ... name of macro ... the macro may not be available ... " If I go to the macro itself and run it from the VBA editor, it runs fine. But, I cannot run the macro by clicking on the shape on my laptop. Does anyone know of what may be wrong?
Thanks,
Steve
On my desktop, I have created a workbook with command buttons and graphic shapes and have assigned macros to them. With the command buttons, in the Developer mode I click on "View Code" and assign macros there. No problems.
Also on the desktop, I have inserted several shapes and have assigned macros. I right click on the shape and then click "Assign Macro". No problems.
Now I go over to my laptop and open the same workbook. The command button shapes work fine. But the macros assigned to the shapes do not run. I get error message ... "Cannot run the macro ... name of macro ... the macro may not be available ... " If I go to the macro itself and run it from the VBA editor, it runs fine. But, I cannot run the macro by clicking on the shape on my laptop. Does anyone know of what may be wrong?
Thanks,
Steve