Microsoft Excel Question:
Download Questions PDF

When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?

Answer:

There are buttons from the Forms toolbar and there are buttons from the Control Toolbox. If "Assign Macro" is not an option then it's from the Control Toolbox.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How do I run a macro every time a certain cell changes its value?I have a user defined function that does not recalculate?