View Single Post
  #2   Report Post  
Posted to microsoft.public.vb.winapi,microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Sheet Tabs: API manipulation to a multiline TabControl

I doubt the sheet tabs are windows. Anyway, do your users know about the
built-in sheet list feature (right-click on one of the four little arrow
heads in the lower left corner of the worksheet window)?

--
Jim
"Nile_Hef" wrote in message
...
| 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.