If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.
A)Use Relative Reference
B)Use Absolute Reference
C)Use Mixed Reference
D)Use All References

Question

Quizplus · Accepted Answer

When creating a macro using keyboard navigation, it is important to select the 'Use Relative Reference' button to ensure that the actions recorded are relative to the current active cell, rather than being absolute references to specific cells. This allows the macro to be used on different areas of the worksheet without needing changes to the cell references.

If You Will Be Using Keyboard Navigation When Creating a Macro