Quote Originally Posted by chapel View Post
The macro is not supposed to open the template, as it's open already.
Why is the template open? Close it and only use the actual workbook based on the template

And I don't get those ref errors on any of my computers.
We all do as we don't have the information or cells that Ref error refers to.