You can go here and can modify the code as per your need
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mel
Sent: 27
can u share the sample workbook
On Tue, Nov 27, 2012 at 8:01 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*You can go here and can modify the code as per your need *
* *
*http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/*
* *
* *
* *
* *
*Regards*
*Rajan