Can I hide data on a sheet when visible but it print it when I select print

[ghrek]

Hi

I have a workbook that data in cells A9:D23 I need hiding when the sheet is visible but I need the data printing from the sheet when I print.

The data that goes into cells A9:D23 are further down the workbook and are linked.

I had protected the cells so couldn't amend but people got confused so think easiest way is to hide when viewing but print

Can this be done?

 

[GWteB]

data in cells A9:D23 I need hiding when the sheet is visible

Hiding only those cells is not possible, you will have to decide whether to hide the columns (A:D) or rows (9:23).

 

[ghrek]

Thought that was going to be the case.

I can shade it with a macro , un shade when print and re shade cant I?

When shaded it will still load the data but just not show it

 

[JoeMo]

Maybe something like this:

Sub PrintAll()
Application.ScreenUpdating = False
With ActiveSheet
    .Rows("9:23").Hidden = False
    .PrintOut
    .Rows("9:23").Hidden = True
End With
Application.ScreenUpdating = True
End Sub

 

[GWteB]

I can shade it with a macro , un shade when print and re shade cant I?
When shaded it will still load the data but just not show it

If other content on those columns and / or rows must remain visible, then that is probably the most obvious option, also from a visual point of view.