Disable tool tip text on excel sheet

[barnard89]

Hi
I am using Excel 2000

I have a tree view control on my Excel sheet
The tree view is automatically
displaying tool tip text help when ever I am moving the mouse over it

I do not need this tool tip text I would like to disable that .

How can I do it ?

I am trying writing the code
Treeview1.tooltiptext ="", but it is giving me error

Please suggest

Thanks

 

[combo]

There is no any tooltip property for a control on sheet. You can use MouseMove event to perform some action. Check the code in worksheet's module,
For a control on the userform, the ControlTipText property definbes the tooltip text. Just clear it in properties window in design mode.

combo