Getting past the Worksheet Name character limit?

[Mr B]

Excel 2

Is there any way to get around (or remove) the limit on characters that can be used to name a worksheet? We are trying to get our licenses in a spreadsheet and want to name each sheet with the name of the software. It seems there's a 31 character limit which is not enough for what I need

Is there any wya to remove this limit or increase it or anything like that

Thanks.

 

[Frank Kabel]

Hi
AFAIK there is no way beyond this Excel limit

 

[Bob Phillips]

.... but perhaps you could create directories that are part of the name,
something like

c:\Documents\Superfast Combine\Products Ltd\workbook_name.xls

Just a thought.

--

HTH

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

Excel 2k

Is there any way to get around (or remove) the limit on characters that

can be used to name a worksheet? We are trying to get our licenses in a
spreadsheet and want to name each sheet with the name of the software. It
seems there's a 31 character limit which is not enough for what I need.

 

[Dave Peterson]

Or use a worksheet as a table of contents/cross reference:

Fill it with hyperlinks that go to A1 of that worksheet (and use a second column
for the description and long name).

If you kind of like that idea, you could use some code that David McRitchie has
that builds the table of contents for you.

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