![]() |
#1
|
|||
|
|||
![]()
Hello!
I just completed a 3 month long project that has a few dozen macros, a module, and 4 forms. The application runs exceptionally well and will revolutionize our reporting system. Basically, when prompted, a userform opens, and there are buttons on each page/layer/level of each userform that run different macros, open different applicable documents or folders, open relevant web pages, paste different auto texts, etc. However, moving it from my PC to other PCs has been a little challenging. In testing it between PCs, I have been doing this: In the VBA window within Word, drag the modules and forms to "Project" instead of "Normal" Save the document with macros enabled Email the document to another user/PC Open the document, drag each module and form from "Project" to "Normal" That works very well. However, I don't want several dozen entry level employees having to work within the VBA window. I can write a "How to" document, and attach the modules/forms to that document, but if there is a way I can have it do it automatically, that would be fantastic and streamlined and save me having to go help half of them with installing it into their Word. Any help or suggestions welcomed! Thanks!! Also special thanks to everyone who has answered my dumb questions on here. This is going to save us thousands per month (and they may give me a raise/bonus.. we'll see!!!) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jude24Joy | Word VBA | 5 | 02-01-2017 04:20 PM |
![]() |
Officer_Bierschnitt | Excel Programming | 5 | 11-18-2015 12:28 PM |
![]() |
Greg S. | Excel Programming | 2 | 07-30-2013 01:38 PM |
![]() |
cartoonist | Word | 10 | 08-15-2012 04:01 PM |
the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |