Set Length of Worksheet Name

[bobkap]

In my macro, what code would I need to have to have my worksheet name be 6 characters long? (Or any set number of characters for that matter.)

I also posted this on mrexcel.com with this link:

https://www.mrexcel.com/forum/excel-questions/1018927-set-length-worksheet-name.html