MS excel have a hidden powerful feature, a macro programming language called Visual Basic for Applications (VB 6.0). It is an event-driven and object-oriented programming language for writing macros for Microsoft Office applications which includes a window for writing code, debugging code, and code module organization environment. Following steps will take you to developer mode…