protected document with spellcheck macro not working for others "Gailc" <gcoulthard[ at ]indigo.ca> 04.07.2006 14:57:20 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

Re: protected document with spellcheck macro not working for others Cindy M -WordMVP- <C.Meister-C[ at ]hispeed.ch> 04.07.2006 15:56:23 Hi Gailc, [Quoted Text] > 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 :-)

Re: protected document with spellcheck macro not working for others Jay Freedman <jay.freedman[ at ]verizon.net> 04.07.2006 16:17:57 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On 4 Jul 2006 07:57:20 -0700, "Gailc" <gcoulthard[ at ]indigo.ca> wrote: [Quoted Text] >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

Re: protected document with spellcheck macro not working for others "Gailc" <gcoulthard[ at ]indigo.ca> 04.07.2006 16:54:31 Thank you both very much. I now have a usable protected form with spellcheck. The macro is now stored with the template. Gail Jay Freedman wrote: [Quoted Text] > 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 FAQ: http://word.mvps.org > Email cannot be acknowledged; please post all follow-ups to the > newsgroup so all may benefit. > > On 4 Jul 2006 07:57:20 -0700, "Gailc" <gcoulthard[ at ]indigo.ca> wrote: > > >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