WHAT IS MACRO?

A macro is a small program that can be used to automate a frequently-repeated process. In Microsoft Office applications, they are: recorded, written from scratch (because it’s something you can’t record), or recorded & edited created using a program language called Visual BASIC for Applications (VBA) triggered using shortcut keys or buttons attached to different events – e.g. opening or closing things, or changing sheets in Exce