Adding another macro in the macro list

NoSparks · #1 11-06-2018, 04:10 AM

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.

Marcia · #2 11-07-2018, 04:13 AM

Thank you. I will try this tomorrow, I hope I will get the instructions right.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding a function to this macro:	JohnGanymede	Excel Programming	6	12-22-2017 02:57 PM
Adding to a macro	Ulodesk	Word VBA	4	03-07-2016 01:40 PM
VBA Code for adding Macro to QAT	OTPM	Project	4	08-22-2013 01:33 PM
Adding macro to normal.dotm programmatically	etippelt	Word VBA	6	04-08-2013 05:55 PM
Macro for automatically adding filename without .doc	RPM7	Word VBA	0	04-29-2010 01:43 AM