how to automatically update hyperlinks inside text boxes?

Hello,

I just registered onto this site and I hope someone can help me with an Excel hyperlink problem. We have a situation where there are 175 different flow diagrams constructed in Excel with customer hyperlinks embedded inside text box objects. The client recently changed server locations so now none of the hyperlinks work and they all need updated to the new server location. I've played around with the hyperlink edits but have not found a way to globally update the hyperlinks that are located within objects like text boxes. Does anyone have a quick and easy way of doing this without having to go to each individual hyperlink to update them?

As I had mentioned above, we have 175 different flow charts where the number of hyperlink updates can range from 2 to 16 that are embedded inside the text boxes. It will be a long time-consuming process to edit each one individually. Any help that you can provide me would be greatly appreciated.

Thanks

Thanks for the reply CK76

Your explanation is a little bit beyond my understanding of what to do but I forwarded your code onto on of our VBA guys to get it to work. In the meantime we just created a basic macro to execute the hyperlink change within the text boxes which has saved us a lot of time.