Hi Sunny,

Try assigning the following code to a button from the Forms toolbar:


Public Sub Tester()
ActiveSheet.UsedRange.Formula = "=Sheet3!A1&"""""
End Sub


---
Regards,
Norman



wrote in message
ups.com...
I need an excel sheet to automatically run a macro on click command, so
that this formula

=Sheet3!A1&""

is inserted in all cells in the worksheet.


Please advise on how i can go about doing this.

Cheers!
Sunny