My formula should also work and it does on first try. When I protect the sheet (unlock the cell with the hyperlink), save the workbook, close it, open it again and click on the hyperlink I get the same error message and it doesn't work anymore.....