To hide the columns or rows, do the printout, and then unhide them.Įxample: Private Sub Workbook_BeforePrint(Cancel As Boolean) Use the function in the code editor (VBA): Private Sub Workbook_BeforePrint(Cancel As Boolean) When I needed to do what you're saying, what I would do is: This is under “Shape Options” → “Size & Properties” → “Properties”.) (by clearing the “Print object” checkbox). Under Properties, you can select if the shape is printed or not Right click on the shape and select “Format Shape”.If you do that, the formula ( =D15) will display literally. Configure the shape to display the content of the desired cell,īy selecting the shape and then typing a reference (e.g., =D15).Or no fill to let the underlying cell’s fill color show through Set the fill color to whatever you want for the background color, Position it over the cell where you want the data to appear.įormat it visually as you want. In that case, for each cell that that you want to display but not print: If that’s good enough for you, you’re done.īut you might want the excluded cell(s) to appear inside the print area Put the cell(s) that you don’t want to print outside the print area. It builds on the idea of using a “Print Area”, This solution doesn’t require you to take special actionīefore and after each time you need to print the file.
