Missing Template reference

[JimNicholls]

Every user has a template that is stored locally on their PC in the
Office11\Startup folder. This template references another template stored on
the server and loads up a menubar on startup. On certain PC's, when the user
try's to use the menubar, their receiving the errmsg "The macro cannot be
found or has been disabled".

The macro security setting is set to medium, and I've checked the tickbox to
trust all installed add-ins and templates.

When I visit the user who gets the errmsg I look in tools\templates and
addins and the checkbox referencing the template on the server is unchecked.
Simply checking this resolves the problem.

Does anyone know why this would happen? I originally it could be a blip on
the server so I stored both templates locally, but I still get the same
problem. I'm thinking the only way to fix this would be to programmatically
remove and add the reference on startup, but I'd like to avoid this is
possible as I'd have to roll out the changes to all PC's.

Is this a known problem?

Thanks in advance.

 

[Charles Kenyon]

Put your template in the Word startup folder rather than the Office startup
folder. The user must check the macro security option to trust installed
templates and Add-Ins. The Word startup folder is a trusted location; the
Office startup folder is not.

See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[JimNicholls]

Thanks for the reply.

The default Word startup location is set to C:\Program Files\Microsoft
Office\OFFICE11\startup.

I assume the Word startup folder your talking about is with the Application
Data\Microsoft\Word folder.

How would changing this resolve my problem? The problem I'd have is that
users move machines, therefore storing it in the Office11 startup folder
enables any user to use the macro when logged on.

Why is it working for some and not for others?

 

[Charles Kenyon]

The folder I am talking about is the folder designated as the Word startup
folder under Tools > Options > File Locations. If that is set to be the
OFFICE11\startup, then it is. Mine is not and I don't know what the defaults
are.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[JimNicholls]

Ok, so the template is stored in the correct folder. Does anyone have any
idea why the template reference in tools/templates & addins is lost? Or maybe
a better question, how can I check for this reference and add it if its
missing?

I know how to add the reference on startup in VBA, but the code wouldn't run
if the reference is missing.

Thanks again for your time.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SmltTmljaG9sbHM=?=,

I've been running into this issue at a client with "template sets" built along
the same lines as you describe. The only reliable method we've found is to put
code in the "lowest level" template that checks the Add-ins collection for the
template name and that .Installed = true

If it's not in the collection it needs to be loaded and installed.

We haven't tracked down everything that can do this, but in a general sort of
way it appears to be conflicts or problems coming from other Add-ins (also COM
add-ins). If something fails, all loaded Add-ins tend to be disabled
(Help/About/Disabled items).

Every user has a template that is stored locally on their PC in the
Office11\Startup folder. This template references another template stored on
the server and loads up a menubar on startup. On certain PC's, when the user
try's to use the menubar, their receiving the errmsg "The macro cannot be
found or has been disabled".

The macro security setting is set to medium, and I've checked the tickbox to
trust all installed add-ins and templates.

When I visit the user who gets the errmsg I look in tools\templates and
addins and the checkbox referencing the template on the server is unchecked.
Simply checking this resolves the problem.

Does anyone know why this would happen? I originally it could be a blip on
the server so I stored both templates locally, but I still get the same
problem. I'm thinking the only way to fix this would be to programmatically
remove and add the reference on startup, but I'd like to avoid this is
possible as I'd have to roll out the changes to all PC's.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail