Hi Paul,

Thanks for the response.

By based on the template do you mean the normal template? I have tried this but then if colleagues open it on their computer this doesn't work.

I have made the VBA starting with "Private Sub Document" is this the issue?

thanks,