If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need advice , where to put my VBA code
Hi everybody,
I'm working on a project that I need to add several macros to do certain things like import images, import charts , import tables , make TOC table, make chapters and ..., but we also might have over 20 different designs ( the format will be the same the only thing will be different is the color scheme and background images in master) I'm not sure I have to create 20 templaes and put the same code in each of them or I have to save my code as an addin and add them in each template? -- Best regards, Edward |
#2
|
|||
|
|||
Need advice , where to put my VBA code
Edward,
It would be easiest to have to the code in an add-in. This would make it available to all the templates once it is loaded. Regards, Shyam Pillai Handout Wizard http://skp.mvps.org/how "Edward" wrote in message ... Hi everybody, I'm working on a project that I need to add several macros to do certain things like import images, import charts , import tables , make TOC table, make chapters and ..., but we also might have over 20 different designs ( the format will be the same the only thing will be different is the color scheme and background images in master) I'm not sure I have to create 20 templaes and put the same code in each of them or I have to save my code as an addin and add them in each template? -- Best regards, Edward |
#3
|
|||
|
|||
Need advice , where to put my VBA code
Thanks Shyam , by the way I have used your wonderful website many times and
thanks for all your tips and codes to the VBA community. -- Best regards, Edward "Shyam Pillai" wrote: Edward, It would be easiest to have to the code in an add-in. This would make it available to all the templates once it is loaded. Regards, Shyam Pillai Handout Wizard http://skp.mvps.org/how "Edward" wrote in message ... Hi everybody, I'm working on a project that I need to add several macros to do certain things like import images, import charts , import tables , make TOC table, make chapters and ..., but we also might have over 20 different designs ( the format will be the same the only thing will be different is the color scheme and background images in master) I'm not sure I have to create 20 templaes and put the same code in each of them or I have to save my code as an addin and add them in each template? -- Best regards, Edward |
Thread Tools | |
Display Modes | |
|
|