Treeview expanding when saving a workbook

P

Paul Delke

When I save a workbook in Excel 2003 the treeview expands, showing all nodes.
I added code to the before save event and that works, but the AutoSave
doesn't fire this event. It also does this in XL2000 & XP.

How can I stop this?

Thanks,
Paul
 

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
Why is TreeView updated/refreshed when saving workbook? 0
treeview drag/drop problem 1
Treeview - Expand all parents of node 3
Save workbook without shapes 0
Persisting Treeview in VBA 5
Uncheck child nodes if parent node is unchecked in treeview 3
Treeview - XML editor in VBA 0

Top