Excel Clear & Print Macros
Budget: $30 – $250 AUD
My order-placement workbook gets hammered all day and I need a quick reset at the end of each transaction. Please add two VBA buttons directly onto the sheet:
1. “New Order” should wipe only the cells that hold both customer information and order-detail fields—nothing else on the sheet is to be touched, formulas and protected areas must remain intact.
2. “Print Order” should send just the defined order section (the same range we fill in) to the default printer, formatted exactly as it appears on screen. Any header or footer already set in the file must stay.
Both buttons need to be easy for non-technical staff to click, with the code stored in the workbook (not personal macro workbook) so it travels if we email the file. A brief comment block in the module explaining the key ranges will be plenty for future tweaks.
1. “New Order” should wipe only the cells that hold both customer information and order-detail fields—nothing else on the sheet is to be touched, formulas and protected areas must remain intact.
2. “Print Order” should send just the defined order section (the same range we fill in) to the default printer, formatted exactly as it appears on screen. Any header or footer already set in the file must stay.
Both buttons need to be easy for non-technical staff to click, with the code stored in the workbook (not personal macro workbook) so it travels if we email the file. A brief comment block in the module explaining the key ranges will be plenty for future tweaks.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Visual Basic for Apps
Excel VBA
Excel Macros