Changing the max length of a worksheet name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Names using Macros 5
Auto worksheet name? 1
Copy worksheet from one workbook to a master workbook 2
Need Macro to Collect Multiple Worksheet Names 3
Auto worksheet name? 1
Donot allow user to change name of the worksheet 2
Using Worksheet Name in Code/Formula 4
Copying info from worksheet to worksheet if info matches 2

Back
Top