VBA Extensibility
 

Is it possible to control the TreeView control on the Project Explorer
window in the Excel VBE?

VBA Extensibility
 

I don't believe you can "control" it directly? What do you want
to do?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"R Avery" wrote in message
...
Is it possible to control the TreeView control on the Project
Explorer
window in the Excel VBE?

VBA Extensibility
 

I want to be able to programmatically expand and collapse folders and
projects.

VBA Extensibility
 

I don't think you can do this. If you use the Show method on a
CodePane object, the right folder will be opened in the tree view
control, but I don't think there is any way to close a tree view
folder.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"R Avery" wrote in message
...
I want to be able to programmatically expand and collapse
folders and
projects.

VBA Extensibility
 

Thanks for the help!