Found what could be a the cause of an issue where if my workbook name is changed the script created links dont work anymore. If I create a link by hand it looks like this in the box you get when you hover over it
file:///C:\Users\William\Desktop\GradeBookFilledInV2.xlsm - 'Test 2014'!A1
but when the script make the link it looks like this
file:///C:\Users\William\Desktop\GradeBookFilledInV2.xlsm - '[GradeBookFilledInV2.xlsm]Test 2014'!A1
What would be the cause of that extra part being put in? If I edit that link it ends up looking like the first one. Here is the part(s) for the link creation

This places the newly created sheet with name from the useform in textbox 'termbox' as the last sheet
Please Login or Register  to view this content.
This adds the link to the dashboard for easy navigation
Please Login or Register  to view this content.
Can anyone see what I may have done wrong to cause this?

Thank you for looking