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...