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

Ooh *SHINY!*

I didn't know about that menu. And if there's more than 16 sheets, clicking
the 'More Sheets...' menu option opens the 'Activate' dialogue, which I can
slip into the toolbar with this line of code:

Application.Dialogs(xlDialogActivate).Show

Thanks for that.

NH

"Jim Rech" wrote:

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