Open Form - Automatically enable Macros

[LRay67]

Is there a way when opening a form that it automatically enables the Macros
for the users without the popup for them to select Enable Macros?

Any help would be appreciated. Thanks

Linda

 

[Jay Freedman]

Is there a way when opening a form that it automatically enables the
Macros for the users without the popup for them to select Enable
Macros?

Any help would be appreciated. Thanks

Linda

No, there isn't, and never will be.

The reason is that if you can do it, the nasty folks who write viruses can
also do it. That would make the macro security settings completely useless
(instead of just annoying, as they are now).

The only thing you can do -- if it makes economic sense in your situation --
is to get a digital signing certificate and sign all your code. That's quite
expensive for anyone except a corporate developer.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Doug Robbins - Word MVP]

What type of form is it? If it is a template that is stored in a trusted
location (The user's template folder, or the work group template folder) and
the user uses File>New to create a document from the template, they will not
get the macro warning.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Gordon Bentley-Mix]

Linda,

Jay is quite right; there is nothing _you_ can do to make your macros enable
automatically, apart from getting a digital certificate - and even then the
security warning may be displayed under certain circumstances. However, there
are things you can ask your _users_ to do that may help:

You can ask them to set their macro security to Medium - which looks to
already be the case as they are being prompted about enabling macros. Then
you can ask them to ensure that your form / template is published to a
"trusted location". In most versions of Word currently in use, this means in
one of the locations specified in the Options dialog for User or Workgroup
templates. (Word 2007 is a bit different in that you can set other locations
as "trusted" as well - altho I'm not too sure about how well this works as
I've seen more than a few posts on the subject.)

And of course, you could always ask them to set Macro Security to Low - but
MSFT recommends against this and so would I, as I wouldn't want the liability
for allowing a virus to get in.
--
Cheers!
Gordon

Uninvited email contact will be marked as SPAM and ignored. Please post all
follow-ups to the newsgroup.