| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy way to Hide & Show Rows and update associated macros
I have a large multi-tabbed workbook that we use as an Estimating tool.
Each worksheet contains many categories with various parts and pricing under each category. We use buttons and macros to hide and reveal the parts under each category. Whenever we need to add a new category or additional parts to an existing category (i.e. add in additional rows), the hide and reveal macros need to be manually updated with the new row numbers - very time consuming! Is there an easier way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy way to Hide & Show Rows and update associated macros | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Hide rows but show when printing | Excel Discussion (Misc queries) | |||
| Hide rows and update fileds in different sheets | Excel Discussion (Misc queries) | |||
| Hide and show Rows | Excel Discussion (Misc queries) | |||
Linear Mode
