Gray Treeview item in VBA
 

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

Gray Treeview item in VBA
 

Lot of obbjects in Excel have a visible property which you can set to either
True or False. You can make picture and chart invisiable using this method.

"Joseph Felcon" wrote:

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

Gray Treeview item in VBA
 

Sorry, I should have added that the .Visible property for individual treeview
items appears to be "read only" and attempts to assign same programmatically
yield a run-time error with that explanation (i.e.: "property is read only").

"Joel" wrote:

Lot of obbjects in Excel have a visible property which you can set to either
True or False. You can make picture and chart invisiable using this method.

"Joseph Felcon" wrote:

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