Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide rows
Hi,
New to VBA. Want to unhide rows based on a YES or NO response. Any help appreciated. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide rows
You will need to set the rows().hidden property to false.
Ask the user which row vtemp = msgbox "which row do you want to unhide Perform the hidden = false method if isnumneric (vtemp) then Rows(vtemp & ":" & vtemp ).Hidden = false Regards, Stewart Rogers "lennyx2" wrote: Hi, New to VBA. Want to unhide rows based on a YES or NO response. Any help appreciated. Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide rows
Although your answer is most likely correct, i'm a bit confused with response
probably due to my limited knowledge of VBA. Can you give it another shot in layman's terms? Thanks. "Datasort" wrote: You will need to set the rows().hidden property to false. Ask the user which row vtemp = msgbox "which row do you want to unhide Perform the hidden = false method if isnumneric (vtemp) then Rows(vtemp & ":" & vtemp ).Hidden = false Regards, Stewart Rogers "lennyx2" wrote: Hi, New to VBA. Want to unhide rows based on a YES or NO response. Any help appreciated. Bob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide rows
Each column and row has a hidden property. You must change that property to
false if you want to display the row: Example: Unhide row 2 Rows ("2:2").hidden = false You asked for the ability of the user to tell you which row so I used a message box to ask the user which row. See example below for the message box. "lennyx2" wrote: Although your answer is most likely correct, i'm a bit confused with response probably due to my limited knowledge of VBA. Can you give it another shot in layman's terms? Thanks. "Datasort" wrote: You will need to set the rows().hidden property to false. Ask the user which row vtemp = msgbox "which row do you want to unhide Perform the hidden = false method if isnumneric (vtemp) then Rows(vtemp & ":" & vtemp ).Hidden = false Regards, Stewart Rogers "lennyx2" wrote: Hi, New to VBA. Want to unhide rows based on a YES or NO response. Any help appreciated. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
How to Hide and Unhide Rows | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
Hide Unhide Rows | Excel Discussion (Misc queries) | |||
How to hide and unhide rows | Excel Programming |