Forum Discussion

Noam Rotman's avatar
Noam Rotman
Copper Contributor
Mar 01, 2018

Object visibility when group rows

When grouping rows in Excel, objects that I have embedded (like list box) are not grouped and still showed. Is there a way to automatically hide the objects when grouped?

2 Replies

  • Noam Rotman's avatar
    Noam Rotman
    Copper Contributor
    Thanks! In "Format Control" under "Properties" I changed the "Object positioning" to "Don't move or size with cells" and it solved my problem.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    You'll have to check the properties of those objects and make sure they are set to move and hide with cells.

Resources