Sorted hyperlinks change target

[netxtown]

I have abandoned using command buttons - and am down to using hyperlinks. That said, hyperlinks seem to suffer their own set of issues when trying to sort a column of them. Not only did they not sort correctly (alphabetical) but oddly enough the actual link changed as well. So what initially was hyperlinked to A1 on Acct01....now points to A1 on Acct 07.

Is there any VB code that would stop this from happening with the sort?

 

[netxtown]

Well - I had to abandon using hyperlinks as I could NOT get them to sort and maintain their targets. So, I was back to using command buttons. And after a few days of trying different scenarios - I got one to work!!!

I have posted my "solution" under the post titled

Command buttons not sorting - and sometimes jumping around on sort​

 

[Peter_SSs]

Hi, Just letting you know that I have removed the 'Mark as solution' from post 2 as it wasn't actually a solution to your question about using hyperlinks. Glad you solved it with the buttons though.