You can enable macros in Excel using the Trust Center or enable a specific macro from the security warning at the top of a spreadsheet.
To change the cell background with VBA Editor in Excel follow these steps: Launch Microsoft Excel. Click the Developer tab, then click the Visual Basic button. Once the VBA Editor is open, type the ...