shared template macros not saving in .docm for some users
Posted on 2009-04-22
Hi experts. I'm hoping someone can assist with this because I am stumped.
I've created a set of shared templates housed on a network. The templates include a variety of automation and VBA code(macro enabled). The users access these templates through a front-end menu system. They choose a document they want to create and the system opens up a new document based on the appropriate template stored on the network. If a user doesn't complete the document they are working on, they save it as a .docm file and can go back into it later to work on it.
For most users, this works without incident. For some users, once they've save the document as a .docm file, when they go back into it, they lose their automation, but not all of it. I've checked the VB coding and project info for both a working document and a non-functional document. The references for the working document point to the shared template. For the non-functional template the reference points to the normal template.
Can someone explain why this happens or how to correct? Is it a setting on a user's individual machine or is it something to do with my coding? Any assistance you can be is greatly appreciated as I've run up against a bit of a mental block on this one.
I've spoken directly with one of the users having the problem. I will outline it below.. They create a new document using the template on the network. All is fine and all functionality is there. The save the document as a .docm file. As long as they remain in the document all is fine. They exit word and then go back into the document, they receive the following message:
File In Use
IMAGE ICAP.dotm is locked for editing by ...
Do you want to:
Open a Read Only copy
Create a local copy and merge your changes later
Receive notification whent he original copy is available.
whatever option they pick, they lose the functionality from the template. Specifically, the macros are gone and when you look at the VB editor, the reference to the templateproject from the network is not there. It references the normal template instead.
Again, out of a couple hundred users this is only happening to a handful of people. All are on windows XP. There is another small group on Windows Vista that experience the same problem but I initially split that out thinking it was isolated to Vista.
Any guidance would be greatly appreciated!