To work with VBA/Macros, one of the first things you must do is enable the Developer Ribbon aka Menu. Excel, by default, has the Developer Ribbon turned off. Enable it via the Options in the File Tab.
Do the following steps. The video below will show you the steps. Recommended using full-screen |