Programming button funktion in Excel sheet

Question

Hi, I want to add a button function that opens or closes certain predefined rows or columns in my Excel sheet.&nbsp;I need this help as soon as possible.&nbsp;Thank youPierre59

hansvogelaar · Answer

Pierre59&nbsp;
For example, create a macro
Sub ToggleRows11To20()
    Range("A11:A20").EntireRow.Hidden = Not Range("A11").EntireRow.Hidden
End Sub
Insert a button from the Form Controls section of the Controls dropdown on the Developer tab of the ribbon, and assign the above macro to it.
You can modify the macro as needed.

Forum Discussion

Programming button funktion in Excel sheet

1 Reply