Forum Discussion
AnisGupta
Jan 05, 2022Copper Contributor
I am not geting the Assign Macro option in right click of button i created by shapes
EXcel 2007 I have run View->Macros-> record macro And some stuff to record and after i stopped the macro. Now i want to assign the the record macro to my Button i created by shapes. But i am no...
AnisGupta
Jan 14, 2022Copper Contributor
You should get a right-click menu with Assign Macro if you create a command button from the Form Controls group.
I created the control button through" Incert->Shapes-rectangle" and after creating macro i want to assign with right button click but i am not getting Assign macro option. Attached screen shot.
HansVogelaar
Jan 14, 2022MVP
That looks like the right-click menu of a cell, not of a shape.
If your rectangle has no fill color, you should right-click its edge.
- AnisGuptaJan 19, 2022Copper Contributor
HansVogelaar Thanks for your suggestion. the solution help me solve the problem.