Hope this isn't a dumb question, but................ Charlie_Chaplin <cchaplin[ at ]thisisnotarealaddresssodontwritemehere.com> 07.06.2006 19:12:08 I've noticed that the macros I've recorded show up in the "NewMacros" under the "Normal" part of the Project Explorer in the VBA IDE. I assume that means all the code is in the Normal.dot file in the Word Startup folder. [snare drum roll] So ... here's my dumb question: What if I'd rather not add anything to to Normal.dot and would rather create a file named "AllMyMacros.dot" that will always load no matter what document I'm working in? Any macro I record or code should automatically go in that file so that I can leave Normal.dot alone?

Re: Hope this isn't a dumb question, but................ "Jean-Guy Marcil" <NoSpam[ at ]LeaveMeAlone> 07.06.2006 20:10:52 Charlie_Chaplin was telling us: Charlie_Chaplin nous racontait que : [Quoted Text] > I've noticed that the macros I've recorded show up in the "NewMacros" > under the "Normal" part of the Project Explorer in the VBA IDE. I > assume that means all the code is in the Normal.dot file in the Word > Startup folder. Normal.dot is not normally found in the start-up folder, but in the default template folder or the user template folder. See Tools > Options > File Locations tab for the different path/folder Word uses. > [snare drum roll] So ... here's my dumb question: > > What if I'd rather not add anything to to Normal.dot and would rather > create a file named "AllMyMacros.dot" that will always load no matter > what document I'm working in? Any macro I record or code should > automatically go in that file so that I can leave Normal.dot alone? Create a *.dot file and place it in the Word Start-Up folder (notice this one does go into the Start-Up folder) so that it gets loaded every time you start Word. Now, when creating macros, make sure you select that template (you will need to open it first) and not Normal.dot. I do not think you can automate this part. If you forget (or would rather not open it when creating your macros), just drag the module from Normal to your template in the VBA IDE (Or cut/paste the Sub) when you do et around to opening that template. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE[ at ]CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org

RE: Hope this isn't a dumb question, but................ Steve 09.06.2006 18:23:02 "Charlie_Chaplin" wrote: [Quoted Text] > [snare drum roll] So ... here's my dumb question: No such thing! > What if I'd rather not add anything to to Normal.dot and would rather > create a file named "AllMyMacros.dot" that will always load no matter > what document I'm working in? Any macro I record or code should > automatically go in that file so that I can leave Normal.dot alone? I'm not too familiar with using VBA in Word, but have done so in Excel some time ago. I seem to remember that Excel had a "Personal.xls" file that was in the background that you could store all your macros in. Might be worth checking if Word has an equivalent? Probably not helping ... but worth a try! Steve.

Re: Hope this isn't a dumb question, but................ "Jean-Guy Marcil" <NoSpam[ at ]LeaveMeAlone> 09.06.2006 22:54:10 Steve was telling us: Steve nous racontait que : [Quoted Text] > "Charlie_Chaplin" wrote: > >> [snare drum roll] So ... here's my dumb question: > > No such thing! > >> What if I'd rather not add anything to to Normal.dot and would rather >> create a file named "AllMyMacros.dot" that will always load no matter >> what document I'm working in? Any macro I record or code should >> automatically go in that file so that I can leave Normal.dot alone? > > I'm not too familiar with using VBA in Word, but have done so in > Excel some time ago. I seem to remember that Excel had a > "Personal.xls" file that was in the background that you could store > all your macros in. Might be worth checking if Word has an > equivalent? > > Probably not helping ... but worth a try! > > Steve. Template and macros storing are quite different between Excel and Word. One striking example is that when you create a workbook from a template, the code is part of the newly created workbook. Not so in Word. In this particular case, it means that if you update the code in the Word template, documents already created will have access to the new code next time you open them. In Excel, you would have to open all documents and change the code in all of them... Toolbars are also very different. Etc. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE[ at ]CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org