[Pre Step] Macro Microsoft Office

1. Set up the macro
• Activate / Change Macro Security Settings
• enter a macro name and description. Follow these rules for the name: 
• Macro names must begin with a letter and use either letters or numerals. You cannot use spaces, non-alphanumeric characters, or periods.
• Macro names can be 80 characters maximum
• Macro names cannot conflict with the program’s reserved commands or keywords such as Print, Save, Copy, Paste.
• Descriptions are just notes that summarize the macro’s function.
• identify object's hierarchy structure
2. Define The Macro
• ensure where to store/save macro file location
• assign to user interface and keyboard shortcuts
• try to record macro
3. Implement and Testing
• clean some macro code if needed.
• delete any other macro if you don't need.