Actually the outlines are really useful. I typically have up to 5 levelsLevel 1 to 3 will be “User” layers – allowing reveal of areas on the sheet based on user actionsLevels 4,5 are “Design” layers holding helper columns and the like.

The macros allow me to open up the whole sheet.

To open up a single set of rows or columns you just need to identify a single cell within the outlined range. Then,range.EntireRow.ShowDetail = Truewill open the whole outlined area.

You need to be carefull to have spacer rows between outline areas or they won’t always work.