Is it possible to control the TreeView control on the Project Explorer window in the Excel VBE?
R R Avery May 21, 2004 #1 Is it possible to control the TreeView control on the Project Explorer window in the Excel VBE?
C Chip Pearson May 21, 2004 #2 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
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 R Avery May 21, 2004 #3 I want to be able to programmatically expand and collapse folders and projects.
C Chip Pearson May 21, 2004 #4 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
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