Assign Macro to Command button by right click

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.
 
R

Roger Govier

Hi

Is your sheet protected? If so Unprotect first, assign the macro then
Protect.
 
R

Ron de Bruin

Maybe the OP have a controltoolbox button instead of a Forms button on the worksheet
 
S

SANDIND

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Assign Macro Command 2
assign macro - toolbar 2
Assign Macro to Command Button 2
Assign a macro to a command button 3
Assign Macro to Ribbon Button 6
Unable to unassign macro from shape 4
Trying to assign a macro to a command button. 1
Assign Macro 1

Top