mailmaverick
12-03-2013, 05:29 AM
Dear All
I have a workbook named Source.xlsm.
I am processing the data in Source workbook and generating another workbook Destination.xlsm in same folder through macro within Source.
My VBA macro (in Source) also copies some modules from Source into Destination.
In the end I want to protect VBA Project of Destination through my Source's macro.
I have found SendKeys solution but that is not reliable.
Is there any other solution ?
Thanks.
I have a workbook named Source.xlsm.
I am processing the data in Source workbook and generating another workbook Destination.xlsm in same folder through macro within Source.
My VBA macro (in Source) also copies some modules from Source into Destination.
In the end I want to protect VBA Project of Destination through my Source's macro.
I have found SendKeys solution but that is not reliable.
Is there any other solution ?
Thanks.