I have problems with TreeView controls on a worksheet: on reopening the
workbook, they resize the scrollable area; and on saving or closing the
workbook, Excel crashes.

I could use the treeviews on a form, but they are more useful on the sheet,
where they act as a drag-and-drop target for data files, capturing the file
name and path without actually opening the file and displaying cascading
graphic of the network drive and folder structure.

Anyone got a workaround? Or is there a magical API call to prevent the
TreeView hanging Excel?


The relevant files a

Microsoft Excel 2002 SP3
Tree View ActiveX Control - Version 6.0 (SP6)

Using a later version of Excel is not an option; we migrate to XP later this
year, but that's outside my delivery deadline.