View Single Post
  #1   Report Post  
Posted to microsoft.public.vb.winapi,microsoft.public.excel.programming
Nile_Hef[_2_] Nile_Hef[_2_] is offline
external usenet poster
 
Posts: 23
Default Sheet Tabs: API manipulation to a multiline TabControl

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.