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.
 

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

assigning macro 2
assign macro - toolbar 2
Missing Assign Macro Command 2
Buttons re-assigned themselves to the right macro name but in Book 1
How to call Excel add-in macro from a button… 1
Assigning Macro to Form Button 5
Re: Reference must be to a macro sheet? 0
Assigned Macro to button 5

Back
Top