Changing the max length of a worksheet name
 

I am using a macro to split a large workbook into multiple worksheets. The
macro automatically names the worksheets based on the specified column.
However, if the field length is too long it actually has to be manually
renamed. Do you know if there is a way to extend the maximum characters
allowed on workbook names?

Only 31 maximum characters are allowed.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Dedrie" wrote:

I am using a macro to split a large workbook into multiple worksheets. The
macro automatically names the worksheets based on the specified column.
However, if the field length is too long it actually has to be manually
renamed. Do you know if there is a way to extend the maximum characters
allowed on workbook names?