Thank you NoSparks. This is a related question so I am not sure if I need to post a new thread. What code/s do I need to insert to the the macro to disable the highlighting before printing the sheet? I can not use the black option in the print page set up because there are colored objects in the sheet. It is only the highlighting in the row and column that I do not want on print. I have opened the link that you sent but nowhere in the examples can I find a code for disabling the macro.


Meantime, my solution is to go to a cell outside of the print area in order that the 'highllights' won't get printed.