Greetings !

I have one workbook where I have created an USERFORM and 2
macros(modules). (for better understanding I would call this
PROG.XLS)

I want to use this USERFORM and the macro in multiple(different) excel
work books which contains data and which I receive from my client. (for
better understanding I would call this DATA.XLS)

I want to paste(?) the USERFORM and Macros from PROG.XLS to DATA.XLS
automatically (using VBA) so that I can start using DATA.XLS.

I am new to VBA and I would request you to take this into consideration
while providing help.

Also I would like to know if I save PROG.XLS as XLA file would the
USERFORM also be available for all the workbooks

Thanks in advance


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/