The easiest way to do this is to record one macro to hide and another to
unhide ("Tools", "Macro", "Record New Macro"). Then assign the macros to
buttons, or drawing objects by right clicking on them and selecting "Assign
Macro".

"Matt" wrote:

right now i am using the group and ungroup from the data menu to hide
particular rows. i need help (i fairly new to this) creating a macro that
when either a toggle button, or command button is pressed will hide/unhide
the row above it. for instance rows 4&5 are grouped, but row four is
hidden... how can i create a button to put on row 5 to hide/unhide row 4? i
don't like grouping the rows because when i protect the sheet you cannot
group or ungroup the rows...