| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Option button unhide row | Excel Discussion (Misc queries) | |||
| Why won't my unhide command work? | New Users to Excel | |||
| hide or unhide rows with button | Excel Discussion (Misc queries) | |||
| Activex command to Hide/Unhide | Excel Worksheet Functions | |||
| Command Button to Hide/Unhide Rows | Excel Discussion (Misc queries) | |||
Linear Mode
