command button to unhide row
 

Hello
I created 2 option buttons one says standard the other says Non-standard .
If Non-standard is selected I want rows 40 to 43 to unhide. IF standard is
selcted rows 40 to 43 should remain hidden. Thanks in advance !

command button to unhide row
 

How about a toggle instead.
Sub togglehiderows()
rows("40:43").Hidden = Not rows("40:43").Hidden
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Marilyn" wrote in message
...
Hello
I created 2 option buttons one says standard the other says Non-standard
.
If Non-standard is selected I want rows 40 to 43 to unhide. IF standard
is
selcted rows 40 to 43 should remain hidden. Thanks in advance !