Attaching a buttom with an event on VBA
 

If you get a bottom from the Forms toolbar, when you drag it onto the
worksheet, it will prompt to assign a macro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ranjan as usual" wrote in message
...
Dear folks,
I want to add a button to my excel sheet, which when clicked runs the code
that I wrote under the VBA editor. How do I link this button to the code, so
the event fires? My code simply clears the empty rows. Any pointers will be
appreciated.

cheers,

Ranjan