Forum Discussion
I am not geting the Assign Macro option in right click of button i created by shapes
You should get a right-click menu with Assign Macro if you create a command button from the Form Controls group.
If you create an ActiveX command button, double-click it while Design Mode is on. This will create an On Click event procedure in the worksheet module. You can call your macro from that procedure. Don't forget to turn off Design Mode when you want to use the button.
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.
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.
HansVogelaar Thanks for your suggestion. the solution help me solve the problem.