Tooltip for Excel Sheet Tabst

[villy]

Hello to all...
Just wanna know if anybody can help me. I'm also an excel-vba curious and I am wondering if there are any vba codes or something to show a tooltips in excel's sheet tabs. Just for curiousity, any idea or wise thinking will be greatly appreciated. Thanks
God bless us all.

 

[WallyBackman]

Why don't you create a Table of Contents tab and link each sheet to a detailed description?

 

[Jaafar Tribak]

Why don't you create a Table of Contents tab and link each sheet to a detailed description?

That would certainly work and would be one easy possible solution but requires leaving the activesheet which is not a big deal but if the workbook contains many worksheets the popup idea is probably a neater solution.

One idea I have in mind is to add a small custom button to the statusbar just below the sheet tabs clicking on which will display a list of all the worksheets in the workbook. As the user moves the mouse over each item on the list a descriptive tooltip will popup describing the worksheet under the mouse pointer.

This will certainly be difficult to code but it is a nice idea.

 

[villy]

Thanks for all your suggestions I would consider all of those..
By the way I am using excel 2003.

cheers...