Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)ĭon't try to copy the code from this web page the VBE won't be able to interpret unseen web characters. Private Sub Workbook_BeforePrint(Cancel As Boolean) In the ThisWorkbook module, enter the code in Listings A and B. If this isn't open, press Ctrl+R or choose Project Explorer from the View menu. Choose ThisWorkbook in the Project Explorer. Don't worry if you're not familiar with VBA I'll show you exactly what to do.įirst, if you're using a ribbon version, save your workbook as a macro-enabled file (.xlxm). If, for instance, you have more sheets and you want only sheet1 (our active sheet) to print in black and white, you can use a simple Visual Basic Editor (VBE) procedure to make that happen. How to automate black and white print in ExcelĮasy is always the best way to go, but workbooks often have more than one sheet, and those sheets have different printing needs. However, you might have situations that warrant more flexibility. If you always want to print to black and white and you have no other sheets in the file to consider, you can save the workbook with this setting checked, and you're done. Print preview shows only a black and white version.

In the Print section, check the Black and White option ( Figure B).

In the resulting dialog, click the Sheet tab.

Click the Page Setup group's dialog launcher.

(I choose it because it has a lot of color formats.) Now, let's walk through the process: We can quickly illustrate this quick solution using the Excel template shown in Figure A. On the con side, your users must remember to set it if the setting isn't saved. The easiest way to print in black and white is to manually set the print setting. LEARN MORE: Office 365 for business How to print in black and white manually in Excel You can work with any workbook or download the demonstration. Neither way is supported by the browser edition. I'm using (desktop) Office 365 but you can work with earlier versions. TechRepublic and the author were not compensated for this independent review. In this article, I'll show you how to print in black and white manually and using a VBA procedure.ĭisclosure: TechRepublic may earn a commission from some of the products featured on this page. Fortunately, it's easy to print a color sheet in black and white. All of the formats that you've applied to make using the sheet easier can interfere with readability when printing the data. All of those visual clues are helpful to the user, but not always for the person who's viewing a printed copy. You can use them to denote input cells, formula cells, to delineate sections, and much more. Colors are great for readability onscreen while working in Microsoft Excel.

Kutools excel won't print to pdf