Asked by Rheagan Fischette on May 17, 2024
Verified
Jesse wants to set up a button shape so that when users click the button, a macro runs.Which of the following should he do?
A) Change the Cell Link property of the button shape.
B) Assign a macro to the button shape.
C) Assign the same name to the button shape and the macro
D) Assign the same shortcut key to the button shape and the macro.
Assign a Macro
The process of linking a macro (a set of automated instructions) to an action, such as pressing a button or opening a document.
Cell Link
In spreadsheet applications, a reference or connection between two cells whereby a change in one cell affects the content of another.
- Develop proficiency in connecting macros to form controls and personalizing form control settings for user interaction.
Verified Answer
AQ
Adrianne QuiachonMay 17, 2024
Final Answer :
B
Explanation :
To run a macro when a button is clicked, the macro needs to be assigned to the button shape. This can be done by right-clicking on the button, selecting Assign Macro, and choosing the desired macro from the list. Option A (changing the Cell Link property) is used when creating a checkbox, Option C (assigning the same name) is not necessary, and Option D (assigning the same shortcut key) can cause conflicts with other shortcut keys.
Learning Objectives
- Develop proficiency in connecting macros to form controls and personalizing form control settings for user interaction.