On Monday, April 11, 2016 at 9:38:40 AM UTC-4, GS wrote:
This will copy the entire module, resulting in duplicate procedure
names if you don't remove the existing module first. Not to mention
having to do maintenance on every workbook, wouldn't it be easier
(and more productive/efficient) to maintain 1 addin?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Yes, your point is very valid. I will look into the addin technique
that you suggested and report if I have any difficulty. Thank you for
taking the time to reply

Desmond

If you do a lot of this sort of work, addins would be of great benefit.
For reference material you could check out the following books...

http://www.appspro.com/Books/Books.htm

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion