Run Logon button under custom ribbon tab using VBA

Hi..I got the solution & so thought to share so that it will be helpful for others..

the below code will run when excel open & it sends key ALT -> Y ->Y1 which will activiate the button..

Private Sub Workbook_Open()

Application.SendKeys "%YY1"

End Sub

refer below link for details :

http://www.excelguru.ca/blog/2008/08...on-the-ribbon/