LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default Worksheet Tabs - Names & Numbers

I have a workbook with many named worksheets.
The sheets are selected from a ListBox which shows their names.
Is it possible, programmatically, to cause the newly selected sheet's tab to
show the sheet name and the previously selected sheet's tab to revert to the
sheet's index number?
Thus at any given time, the view will be all tabs showing a number and just
one with a name.
--
donwb

--
donwb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet/chart tabs changed names! wgnewman Charts and Charting in Excel 16 February 24th 10 02:22 PM
Sequencial Names On Worksheet Tabs lehigh46 Excel Worksheet Functions 3 January 29th 09 12:52 PM
How do I create a list (Word) of the names on Excel worksheet tabs PT[_2_] Excel Worksheet Functions 3 February 23rd 07 05:24 PM
How do I print worksheet tabs names from exel 2003 Plinius Excel Discussion (Misc queries) 3 February 4th 07 09:49 PM
Worksheet Tabs Names as Dates Pieman Excel Worksheet Functions 4 March 6th 06 11:54 PM


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"