Work Sheet Tab

[Bob Gellenbecj]

Does anyone know how to increase the size of the work
sheet tabs located near the bottom of a work sheet? I am
trying to add a large three word description to a sheet
tab?

 

[Roger Govier]

Hi Bob

The worksheet Tab expands in width automatically, according to the name type
in when you choose to Rename the sheet.

 

[Bob Phillips]

Bob,

They automatically size to the text (at least mine do).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Gellenbeck]

-----Original Message-----
My sheet tab is limited to 30 characters. It increase in

size until it reaches 30 characters then stops. Does any
one know how to increase the number of characters I can
use to describe a worksheet?

 

[Frank Kabel]

Hi Bob
AFAIK you can't increase this numer.
Frank

 

[Dave Peterson]

I can get to 31 <bg>.

You may want to use abbreviations in the worksheet names. Then create an
"index" worksheet that has nice descriptions of what each worksheet does.
Include hyperlinks to that sheet and it'll make it easier to navigate.

David McRitchie has some code to generate the table of contents at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm