| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand and Collapse rows using a macro
I have a Spreadsheet that as time goes on will grow quite large. In Column
A, the data entry person can choose from 4 options (In progress, Sold, Cancelled, Declined). I would like to have all rows (starting from row 8) to collapse to a height=1 except for those that are "In Progress". I would be helpful if the rows would only collapse when file is closed and reopened. Your help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| collapse an expand rows using VB | Excel Programming | |||
| how do i expand and collapse rows | New Users to Excel | |||
| How do I move the expand/collapse for rows and columns in Excel? | Excel Worksheet Functions | |||
| Programming Outlines (expand/collapse rows) in Excel | Excel Programming | |||
| Expand/Collapse Rows | Excel Worksheet Functions | |||
Threaded Mode
