Hey,

I have a workbook that calculates total capacity based on how many people are listed as "present"

I wish to make a printout. So I have the idea of Copy/Pasting the spreadsheet again, and setting all columns/rows I dont need to hide.

Sub Sick_Report()
    ActiveSheet.Unprotect
If ActiveCell = "Capacity" Then
  Selection.EntireColumn.Hidden = True
ActiveSheet.Protect
End If

End Sub
That hides the selected cells column if the cell = Capacity (IE needless info for report)

Is there a way to have this work the same way if I was to select an entire row? (Title Row)

Ill keep trying at the same time.

Thanks in advance!