I'm thinking of including a TreeView 6.0 control in my workbook. I understand this depends on the Visual Basic 6.0 Run-time Files. If I send my workbook to a lot of other people who are running many different versions of Windows, what are the odds that they will all have the Visual Basic 6.0 Run-time Files installed on their system?

Also, can a workbook detect that the Visual Basic 6.0 Run-time Files are missing, and give a helpful message to the user? Right now, if I retitle the MSCOMCTL.OCX to make it unusable, the workbook gives a macro compile error when the user clicks the button to launch the TreeView control. The error is

Microsoft Visual Basic
Compile error:
Can't find project or library

This is not sufficiently helpful for an end user of the workbook.

Thanks for any suggestions. I previously posted this question in the Excel IT Pro Discussions forum at Microsoft, but haven't received any responses there.