07-29-2020 08:17 PM
Whether you want this for print purpose only
If you want the same format in sample excel sent by you, set this design/format in a sheet within the workbook.
Add the following lines (or) send the file i will add.
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False