Anyone,

I am using Office '03 - Excel.

I have a treeview heirarchy, with checkboxes, which is assembled top-down
(of course). After I have completed the heirarchy, I wish to disable (gray
out, hide, make invisible, make unavailable, etc.) items in the top two tiers
of the hierarchy which do not have children in their third (or lower) tier(s).

Short of rebuilding the heirarchy (or imaging the heirarchy in a data
structure before building the treeview), does anyone know of a property or
method that (preferably) leaves items visible and unavailable OR renders the
item not visible?

Many thanks,
Joseph A. J. Felcon