Question

write steps to open the code recorded in a macro​

Answer 1

Answer:

I hope this answer is helping you.

Please mark me brilliant.

Answer 2

Answer:

Following are the steps to record in a macro:

(1)Click the Developer tab.

(2)In the Code group, click on the Macro button. This will open the ‘Record Macro’ dialog box.

Record Macro button in the developer tab in ribbon.

(3)In the Record Macro dialog box, enter a name for your macro. I am using the name EnterText. There are some naming conditions that you need to follow when naming a macro. For example, you can not use spaces in between. I usually prefer to keep my macro names as a single word, with different parts with a capitalized first alphabet. You can also use underscore to separate two words – such as Enter_Text.

Macro Name in the dialog box

(4)(Optional Step) You can assign a keyboard shortcut if you want. In this case, we will use the shortcut Control + Shift + N. Remember that the shortcut you assign here would override any existing shorcuts in your workbook. For example, if you assign the shortcut Control + S, you will not be able to use this for saving the workbook (instead, everytime you use it, it will execute the macro).

Record a Macro in Excel - assigning a shortcut in dialog box

(5)In the ‘Store macro in’ option, make sure ‘This Workbook’ is selected. This step ensures that the macro is a part of the workbook. It will be there when you save it and reopen again, or even if you share it with someone.

Record a Macro in Excel - Store Macro in This workbook

(6)(Optional Step) Enter a description. I usually don’t do this, but if you’re extremely organized, you may want to add what the macro is about.

(7)Click OK. As soon as you click OK, it starts to record your actions in Excel. You can see the ‘Stop recording’ button in the Developer tab, which indicates that the macro recording is in progress.

(8)Select cell A2.

(9)Enter the text Excel (or you can use your name).

(10)Hit the Enter key. This will select cell A3.

(11)Click on the Stop Recording button the Developer tab.

Hope this answer is helpful for you.

Thank you.

PLEASE MARK ME BRAINLIEST