[quote name='prasad' post='783468' date='08-Jul-2009 07:32']amazing. Thanks[/quote]
How can I assign this macro to button? I have inserted a button in one sheet & tryign to assign but no such option is displays. I have done this before but dont remember how.

[quote name='HansV' post='783470' date='08-Jul-2009 08:06']If you want a button on a worksheet:
- Display the Forms toolbar (for example View | Toolbars | Forms).
- Click on the Command Button button
[attachment=84600:x.png]
- Click on your worksheet.
- Excel will ask you to assign a macro.[/quote]
I have already inserted a Command Button button in ws. The problem is that excel is not asking to assign any macro on it. I have tried the same with new WB but no results. ?

[quote name='HansV' post='783474' date='08-Jul-2009 08:28']Did you use the Forms toolbar or the Control Toolbox toolbar?[/quote]
I am sorry Hans, I was using Control Toolbox instead of Forms Toolbr. Now everything is fine. Thanks a lot.