VBA Extensibility

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

Is it possible to control the TreeView control on the Project Explorer
window in the Excel VBE?
 
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 want to be able to programmatically expand and collapse folders and
projects.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

treeview control problems 1
Why is my UserForm event procedure disapeared? 2
Treeview with context menus 1
Custom Toolbar/Menu for UserForm 3
VBA Functionality Lost 1
Workbook doesn't fully close - sorta 4
Need Help 1
Where is the Treeview Control in Excel 2003? 4

Back
Top