Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.vb.winapi,microsoft.public.excel.programming
|
|||
|
|||
![]()
Has anyone ever managed to get a window handle for the sheet tabs control and
run SendMessage TCS_MULTILINE? SPY++ is surprisingly unhelpful: the EXCEL7 window for the active workbook has the expected scrollbars, and three XLCTL windows which I am unable to identify. None of them respond to SendMessage(hwndCtrl, TCS_MULTILINE, 0&, 0&) - actually, I'd be interested to know what these controls are... As for the reason I'm doing this, I have some workbooks here with 20 to 30 tabs, and the users want faster navigation. Yes, I could populate a menubar dynamically with navigation buttons for each worksheet in the current workbook, and dock it to the bottom of the XLDESK window. But I like lazy solutions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
Help with data manipulation between 2 worksheet tabs | Excel Discussion (Misc queries) | |||
Time sheet manipulation | Excel Discussion (Misc queries) | |||
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation | Excel Programming | |||
Data manipulation within the same sheet | Setting up and Configuration of Excel |