Quote Originally Posted by viveksrkr View Post
Thanks a lot. I think I am reaching there...few things -

1) Please note I am using MS Excel 2010 which has different properties than 2003 so I hope that is taken care of in you code. If not, please help
2) I am getting an error at cb2.OnAction "YourMacroName" '<<<< adjust the drop down change macro name
The error is OLE Object failed error. I am not sure how to resove this.
Team - Let me know your views on this...thanks a lot