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!
Bookmarks