I have a workbook template that users can use to create their own copies of it to place their data on. However, I would like it to remind them to open it by double-clicking on the workbook's name instead of by right-clicking on the workbook's name. The reason is so that they can only get a copy of it and not be able to mess with the template itself by putting their data on it.

I tried using the following code inside "This Workbook module" to achieve the above objective but it runs indiscriminately whether I double-click or right-click on the template name. 

Please Login or Register  to view this content.
Also tried this code but still no go...

Please Login or Register  to view this content.
Perhaps, an alternative would be to have a different code to automatically produce a copy of the workbook no matter it opened via the right-click route?