Re: Word 2003 Macro frustration



I know that the template file with my macro in it did not have a digital
signature. This is because I created the template last year.

My only theory based on your input was that the macro security setting was
set to low and that using some shortcut key stroke by mistake I have turned
the setting to high without realising. This as far as I can see is the only
way to explain the sudden appearance of the fault.

Everything is now working again anyway.

Thanks.

"Jialiang Ge [MSFT]" <jialge@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:CVYeRN5mIHA.9932@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello KeithM,

Let me clarify it.

1. "I have tried the macro security setting on both 'medium' and 'low' and
neither had any effect."
Office requires reloading (close, then re-open) the active documents after
we change the macro security setting, so that the new security setting can
apply to these documents that are already opened. Therefore, if we do not
reload the documents after we lower the security setting, their macros
will
still be disabled, and give the illusion that the security setting does
not
take effect. Is this explanation clear for you?

2. Why does the macros work well without security warnings in the past,
but
require security checking now?
In my best guess, there are at least two possible reasons:

A. In the past, your Word macro security setting was "low". "low" means
Word will trust all the macros and will not ask for security permission
interactively.
But by any chances (e.g. Word settings were restored from Word Help ->
Detect and Repair -> Discard my customized settings and restore default
settings, or another user of the computer changed the Word macro
security),
the macro security setting was set to "high", then the warning message
appears. Please also note that the macro security setting is an
application
level setting, so anyone who's given proper permissions to use the
computer
may change it and influence the other users.

B. Is it possible that the template or the macro project had been
digitally signed (but you did not notice it), then the digital signature
was removed by any chances?
See how to digitally sign a file or macro project:
http://office.microsoft.com/en-us/help/HP052495571033.aspx



.



Relevant Pages

  • Re: Reply with attachment macro
    ... which is why my signature is in it. ... attach a particular file rather than use a template." ... So that action would be reply> insert signature> attach file. ... > The macro below will do something close to what you want. ...
    (microsoft.public.outlook.program_vba)
  • RE: Undo button and redo button quit
    ... You haved to enter or make a change to the workbook before you can undo ... "stillkicking" wrote: ... I changed the security setting. ... Tools - Macro - Security - Medium ...
    (microsoft.public.excel.misc)
  • Transferring digital signatures
    ... I have created a template with macros, but to run them my coworkes have ... to set their macro security settings to low. ... I realize this can be solved with a digital signature but to date I ... macro (and becasue I can't change my security settings, ...
    (microsoft.public.excel)
  • How do I clear a visual RUNTIME library error?
    ... This behavior may occur when Word macro security is set at ... Select the Medium security setting, ... Accessing Word startup folder: ... Restart word normally and check if word opens normally. ...
    (microsoft.public.word.application.errors)
  • Upgrade Office 2000 -> Office 2003 + digital certificates
    ... We are in the process of upgrading office on our workstations from Office ... The security setting is set to medium in Outlook. ... When we upgrade to Office 2003 and set the macro security setting to medium, ...
    (microsoft.public.office.setup)

Loading