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