Need a macro which will do the following before print:
Since the code will print the sheet to the default printer, so please make the code in a manner which will allow the user to change the code to set printer to be used by the code irrespective of the default printer already set.
- Clear the back ground color (ie No fill ) except the row containing term ?*total*?
- Print the sheet
- Undo the background color
- save the file
Thanks in advance