VBA stops responding?

M

Maurene Garza

We are using Word 2000, no startup switches, on NT4
desktops.

I have one user who reports that when she runs templates
that contain macros, the templates simply open instead of
run.

My best guess is that the vba code is just not running.
It's not a case of her opening/running the templates
incorrectly.

Also, if she closes and reopens Word, they start working
again.

An example is a template that contains this code:
Sub AutoNew()
ActiveDocument.FollowHyperlink
("http://xxx.xxx.com/forms/filereq.asp")
ActiveDocument.Close
Documents.Add DocumentType:=wdNewBlankDocument
ActiveDocument.Activate
ActiveDocument.Close
End Sub

But this is just an example; another template contains a
user form and does something completely different.

Of course I cannot find anything in the kbase that
applies. I have absolutely no idea what would cause this,
or even what to investigate.
 
C

Chad DeMeyer

Maurene,

Have the user check their macro security setting (Tools>Macro>Security). If
it is High, no macros in templates will run unless the VBProject is
digitally signed and the user has taken explicit action to "trust" that
signature. Have them set the security to Medium, then they will be given a
prompt to Enable or Disable macros.

cjd
 
M

Maurene Garza

That's a good idea - but our macro security is set to
Low. I can't imagine the user would ever have changed it
on purpose - she would have had more frequent problems if
she had. On the other hand, it's always possible that she
is using some arcane combination of keystrokes that's
changing it on her, but....

Any other ideas?
 
C

Chad DeMeyer

You say if she closes and reopens Word, they start working again. Does the
problem reappear, and if so, when?

cjd

BTW, highly recommend macro security be set to Medium rather than Low -
virus scanners alone won't catch all malicious code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top