I do not have the option to assign a macro when I right click a control
button that I have placed on a spreadsheet from the control toolbar.
However, when I insert an autoshape, I do have the option when I right click
to assign a macro. This causes an error in that the file path cannot be
found, even though the macro works when accessed the usual way.

Can anyone help me please??