Assign Macro to Command button by right click

  • Thread starter Thread starter SANDIND
  • Start date Start date
S

SANDIND

Hi,
In my system I am not able to assign macro to command button by right
clicking it and simply selecting the "Assign Macro", the assign macro option
is not showing once I right click. But any file I receice from outside has
that option once i right click.

Do i need to change any of the setting in my excel workbook, Thanks for help
in advance.
 
Hi

Is your sheet protected? If so Unprotect first, assign the macro then
Protect.
 
Maybe the OP have a controltoolbox button instead of a Forms button on the worksheet
 
Thanks Ron, You are Genius . I inserted Form and inserted button, then I am
able to assign the Macro.

Thanks to both of you for the support.
 
Back
Top