Structured "All Levels" BOM: Expand all levels to be visible

[DRoam]

I've already got my Structured view set to "All Levels". Assuming I'm able to figure out how to open the BOM to the "Structured" view (see this post), is there any way to then automatically expand all levels of all rows, so that every row is visible? I'd be perfectly happy with a "right-click-->expand all" button, but unfortunately we weren't provided with that. If I right-click on the beige square on the far left of a row, there's an option to "Expand all Children", but you have to do this for every top-level row.

So, I'm seeking an iLogic/VBA solution. Any ideas?

[clutsa · Accepted solution]

Well... This isn't what you asked for but you can select all the rows (with clicking the top row and holding SHIFT and clicking the bottom row) and then right click expand all children... it's more then you asked to do but isn't to bad of a task.

[DRoam]

Nope, that's a perfect solution! I actually tried that, but to select all rows I tried clicking the top row's square and dragging down to select the rest of them, and it just dragged the top row instead. I didn't think about doing a click first +hold shift + click last. This will work perfectly.

If anyone knows of any even faster ways of doing this, iLogic or not, please let me know. But this is much better than how we were doing it before.

Thanks!

[alex_hiis6PJP6]

If my Structured view is set to display all levels and I have only one row containing an assembly with children, can the 'Expand All Children

' command be executed using iLogic?