template over a workbook?
I do not understand the question. What workbook?
A .DOT file can be:
read-only
locked by OS Permissions
on a network drive
Thus, a user can invoke (call) it and it clones itself into a new document. The original is not touched, as it is never opened.
"so the users in our office simply have to find the template on the shared drive,"
This can still apply. They find the file (say using Explorer), double click it. The .DOT executes Document_New (the procedure fired when cloning a new document).
Document_New can do whatever you want it to do. It is a procedure like any other procedure.
I rarely, if ever, change the FileOpen folder. I have rarely ever seen an actualy need to do this. People change FileOpenDirectory all the time, but more often than not it is because of a misunderstanding.
As for additional features, you are going to have to state what those may be, as ALL features/functionalities are avilable.
Gerry