macro for paste values and transpose

Originally Posted by Debraj Roy

* from where.. is it from any other application..
* Is Alt + E + S + E + V working.. Manually

Please elaborate.. briefly..

This would be from excel.
Alt + E + S + E + V works fine, but I want to make a button on my ribbon to complete the action for me.