macro to create a hyperlink to another sheet, does not work on spaces or symbols

Any direction would be appreciated
I have a userforum with macros that when a user types in the forum a code (such as "hm952336") and then clicks the add button, it creates a new row on one sheet with the code in Column C of that row, the code that is in column c is also a hyperlink to a newly created sheet in the same workbook.

Please Login or Register  to view this content.

The issue is if the code has a space or a symbol (such as "hm9522336 hm9522337" or "hm9522336-hm9522338"), no hyperlink is created.
How can I get the macro to create a hyperlink when a space or a symbol is in it.
Here is the file:

I also tried using a vb code, which would work except for the fact that I have to save it as a webpage, where only a macro can work.

Please Login or Register  to view this content.

just as an idea for the boiling pot

as the sheet reference is only underlying the hyperlink, the visible hyperlink is only a title (which cannot have spaces and or certain characters contained as although use here is not as web link the default use would be.)

what you could do in your create hyperlink macro is find and replace any spaces or dashes with an underscore in the hyperlink title

this is the same principle excel uses when converting table to ranges using headers.

not sure of the exact code to do this but is an option to solve your problem