Why is TreeView updated/refreshed when saving workbook?

J

JimAnAmateur

I am using a TreeView of (Microsoft TreeView Control 6.0 (SP4)) in an Excel
sheet (Excel 2003).

When I click on Save (File | Save), it seems that the TreeView is being
updated/refreshed/rebuilt while saving the file, and after saving, all the
nodes are expanded.

Why?
How can I avoid this "unintentional" save?
or, at least, after this "unintentional" save, how can I Collapse all the
nodes again? I did not find
a) "Work book_AfterSave" (only "Workbook_beforeSave"), and
b) "CollapseAll" in MS TreeView Control that I am using.

Thanks in advance!

br Jim
 

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 6.0 in Excel 2003 2
Persisting Treeview in VBA 5
Treeview expanding when saving a workbook 0
TreeView and RichTextBox don't show correctly (wrong size)? 2
Custom ribbons dissapear when saving?!? 0
VBA croaks on Nodes.Clear if TreeView is *not* Visible. 1
Highlighting treeview node 0
treeview control not a valid embedded object 3

Top