protected document with spellcheck macro not working for others

[Gailc]

Hello,

I seem to be having a problem with a macro I have created in Word 2003.

The macro allows the user to run a spell check on a protected form
(http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm). I have
saved the macro to normal.dot but when anyone else opens the form they
get the macro error message that offers some reasons for the macro not
running.

I do not have a lot of experience with macros - should I be saving
the macro elsewhere that allows others to open it or is there a
security setting that I can set that allows everyone to run the
spellcheck?

This form will be used by 1000+ users - hopefully the most they will
have to do is select "enable" this macro



Thanks

 

[Cindy M -WordMVP-]

Hi Gailc,

I seem to be having a problem with a macro I have created in Word 2003.

The macro allows the user to run a spell check on a protected form
(http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm). I have
saved the macro to normal.dot but when anyone else opens the form they
get the macro error message that offers some reasons for the macro not
running.

I do not have a lot of experience with macros - should I be saving
the macro elsewhere that allows others to open it or is there a
security setting that I can set that allows everyone to run the
spellcheck?

If you saved the macro in your Normal.dot, then other users will not have
access to it when they open the form.

In this case, when you're distributing a form among other users, you
should save the macro in the form-document, so that it travels with the
document. Note that this does mean the other users will need to enable
the macro when they open the document.

If you work in a company with an IT department, you might ask them if
they have a digital signature they can use to sign the macro code
project. If they do, then this is probably already trusted on all user's
machines, so they can open the document and run the macro without
difficulties.

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

 

[Jay Freedman]

The form itself should be a template, and the spell-check macro should
be saved in that template.

If the macro is saved in your normal.dot, it isn't available to anyone
else. And it should not be in their normal.dot (see
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm for the
reasons). The form template is the proper place.

If you send that template to the users, instruct them to save it to
their hard disk. If they open it directly from an email attachment,
that makes a copy in a temporary folder, which disappears when they
close the document. And unless they save it in their Templates folder
(which is a trusted location), they'll have to make sure their macro
security level is set to Medium and click the Enable button in the
opening dialog.

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

 

[Gailc]

Thank you both very much. I now have a usable protected form with
spellcheck. The macro is now stored with the template.

Gail