opening userform in other template Jim <joc[ at ]nospam.net> 02.09.2006 01:53:58 Hello, I have a number of templates that all use the same general user forms that I made with code in the forms and vba macro files. I want to keep the forms/macros with the normal template so that any of the other templates can access them. I want to keep them as one source so that I can fix/update the code all at once. I can access the VBA subroutines with a public declaration but I can not figure out how to access the forms from another template to open them. Any suggestions - ? Thanks, jim joconnor[ at ]aspsm.net

Re: opening userform in other template Cindy M. <C.Meister-C[ at ]hispeed.ch> 02.09.2006 09:51:06 Hi Jim, [Quoted Text] > I have a number of templates that all use the same general user forms that > I made with code in the forms and vba macro files. > > I want to keep the forms/macros with the normal template so that any of the > other templates can access them. I want to keep them as one source so that > I can fix/update the code all at once. > > I can access the VBA subroutines with a public declaration but I can not > figure out how to access the forms from another template to open them. > Put "public" routines in the "parent template" (you say it's all in Normal - make sure you back that up regularly!) that .Show each form. Call these routines. 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: opening userform in other template Jim <joc[ at ]nospam.net> 02.09.2006 15:31:19 Cindy M. <C.Meister-C[ at ]hispeed.ch> wrote in news:VA.0000025c.0070758d[ at ]speedy: [Quoted Text] > Hi Jim, > >> I have a number of templates that all use the same general user forms >> that I made with code in the forms and vba macro files. >> >> I want to keep the forms/macros with the normal template so that any >> of the other templates can access them. I want to keep them as one >> source so that I can fix/update the code all at once. >> >> I can access the VBA subroutines with a public declaration but I can >> not figure out how to access the forms from another template to open >> them. >> > Put "public" routines in the "parent template" (you say it's all in > Normal - make sure you back that up regularly!) that .Show each form. > Call these routines. > > 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 :-) > > Cindy, When I stop hitting my head, I will thank you properly. Thank you very much for your solution. Simple is best. Jim

Re: opening userform in other template Cindy M. <C.Meister-C[ at ]hispeed.ch> 04.09.2006 13:52:42 Hi Jim, [Quoted Text] > When I stop hitting my head... > That's what these groups are for: helping one another :-) When your head's full of zillions of things concerning a project, the "obvious" is so hard to see! If you can't talk about it with others over coffee, a "forum" like this is next best. > Thank you very much > You're most welcome :-) Cindy Meister