command button to unhide row

M

Marilyn

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 !
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating new template - change default heading style 7
command button add another command 5
Help!! find two number recurring numbers in row?? 1
Unhide a row 1
Command button unhides but not hides 1
option button (yes No) to hide rows 3
Run a macro based on a cell value 1
Cannot unhide the hidden rows in my spreadsheet 3

Top