This is not a question of preserving structure, the code I have
written is not dependent on specific row numbers etc. I just need to
prevent more advanced users from hiding rows of data that less
experienced users are having difficulty locating and unhiding again.

Hide/Unhide is not allowed via the UI when sheets are protected. Also,
user input can only be in 'unlocked' cells.

I was refering to sheets that *are structured* for design layout since
that's what most of my projects are configured. I use code to
hide/unhide and/or use Outlines to expand/collapse ranges.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion