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
|