Thread: [Solved] Adding another macro in the macro list
View Single Post
 
Old 11-06-2018, 04:10 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
In those macros, the code that removes the color are
Code:
Cells.Interior.ColorIndex = 0
and
Code:
Cells.Interior.ColorIndex = xlNone
Use the macro recorder to record yourself printing the sheet.
Add one of those lines at the beginning of the recorded macro and print via the macro.
Reply With Quote