Auto Print Button with auto hide and unhide vba

[Diankathrine]

Hi,
I'm new in VBA, I've been searching the internet to solve my problems in excel. I'm preparing a Payslip sheet which contains a Command Button which automatically prints all the payslips.
The sheet contains salary benefits which other employees don't have. Let's say employee 1 is entitled to school fees (meaning the cells contain figures) while employee 2 is not (which means the cell contains 0) so i want to automatically hide the row of an empty or 0 cell value. My problem is how do I automatically hide and unhide rows while at the same time automatically printing the payslips? I will highly appreciate any help.

 

[diddi]

hi and welcome to the forum.

not knowing your code, i can suggest you look at the .RowHeight property.

eg MySheet.Rows(5).Rowheight = 0 will set that row to 0 height

eg

    If cells(9,4) = 0  Then       ' the school fees are in D9 and equal to 0
        Rows(9).RowHeight = 0
    Else
        Rows(9).RowHeight = 11
    End If

 

[Diankathrine]

Thanks Diddi, I will try to sue your suggestion.