Error handling when creating sheets based on list and hyperlink

[gv29]

Hi,

I am struggling to solve for two issues.
1) When I use the code below and a name form my list in the master sheet is >31 characters or uses : /\ ..., I get Template(x) as a name. Is there any way to handle the errors by truncating the names and getting rid of the unallowed characters?
2) I would also like to create an index in another column of the master sheet with the names and hyperlink of the newly created sheets.

The code I am using to generate the sheets is:

Please Login or Register  to view this content.

Thank you very much for your help,

Kind regards,

Guillaume

[JBeaucaire]

1) Add this function to your module, it does what it says it does, you can see in the code where you list the character to remove:

Please Login or Register  to view this content.

2) Amend your code to use that function, as well as select the first 30 character, or 29, whatever you want:

Please Login or Register  to view this content.

[gv29]

Thanks it works like a charm.

Can anyone help me with the second part:
2) I would also like to create an index in another column of the master sheet with the names and hyperlink of the newly created sheets.

Thanks a lot

[JBeaucaire]

CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET
This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. It demonstrates how to also collect some key pieces of data from each sheet to add to the LIST sheet to be more informative. It puts a link on all your original sheets in cell A1 back to this new LIST sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.

Create Hyperlinked List of Sheets

Once the hyperlinks are created for you, you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.

[gv29]

Thanks. It solves partially my issue as what I wanted to achieve is having the hyperlink created in a column next to the projectCell column and only for the newly created tabs.

[JBeaucaire]

The macro demonstrates all the techniques for creating a hyperlink and putting it in a cell. When you adapt those techniques into your specific goal/target then you will have knowingly absorbed this content and made it your own.

[gv29]

Thanks, I manage to sort it out thanks to the concept