Sorry, what I meant was, the macro is not supposed to open the template. But only work on selected cells in the open workbook (which is the one I posted here).
The ref-errors you get, is probably the result of the macro trying to open the original template, (which it does on my pc)
But the problem is, its not supposed to open anything. Its simply supposed to set the background color on selected cells in my active workbook.
So I dont understand why its trying to open the template with the macro code I posted earlier.