Recording on the macro commences promptly immediately after clicking the Close button. Perform the actions you wish to file and also have the macro execute. You'll be able to enter data, format the data, create a chart or graph from the data, include formulas, and other steps. The Format Painter https://www.customguide.com/excel/how-to-lock-cells-in-excel