Hello everybody, I tried to apply this macro on my sheet but there is a problem, hyperlinks are active in some cells not in all cells. I am not really good at macro so I couldn't figure out what is the problem. The yellow cells contain hyperlinks in data sheet but when I click on the cell it goes to data sheet not to the hyperlink. Could you please help me? You can find file attached.. Thank you very much... :D