Question

Name the tab where macro option appear

Answer 1

Answer:

Add a macro button to your own group on the ribbon

Click File > Options > Customize Ribbon. Under Customize the Ribbon, in the Main Tabs list, check the Developer box if it is not already checked. Select the macro you want to add to your new group, and then click Add. The macro is added to the My Macros group.