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.
Remember To Do the Following.... Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link